Issue 119733 - Spreadsheet crashes with message "Due to an unexpected error, Openoffice.org crashed.
Summary: Spreadsheet crashes with message "Due to an unexpected error, Openoffice.org ...
Status: REOPENED
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: 3.4.0
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: Yurggent Alfredo Chable Torrez
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2012-06-04 13:58 UTC by David
Modified: 2019-12-09 15:25 UTC (History)
10 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
report.wer file created by windows (24.88 KB, application/octet-stream)
2013-03-16 18:39 UTC, Paul
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description David 2012-06-04 13:58:02 UTC
Spreadsheet and Writer both crash a few seconds after loading (have not tried any other app).  Sometimes I have enough time to open a spreadsheet.  This happens every time I start the apps.  I can start the spreadsheet or writer app and let it sit with a blank doc and after about 15-20 second the dialog box "Due to an unexpected error, Openoffice.org crashed..." appears. I tells me that the doc I'm working on will be saved and presents me with a "Close" button at the bottom of the dialogue. I click the close and this dialogue stops responding.. Have to force it closed via windows.
Comment 1 Andre 2012-06-08 09:44:53 UTC
Can anybody reproduce this?
Comment 2 Regina Henschel 2012-06-08 09:59:49 UTC
I had a similar problem myself and heard it from others. The reason had been a faulty file registrymodifications.xcu. I could not find out, why the file gets faulty.
@David: Please search for this file in your OpenOffice user folder in your Windows profile and rename it. It will be regenerated with the next AOO start. Please report back, whether this solves your problem.
Comment 3 David 2012-06-08 19:38:41 UTC
Hey Regina.  Your suggestion worked.  I had the spreadsheet open for over an hour with no crashes.

Thanks
Comment 4 Terry Yang 2012-06-20 06:38:17 UTC
Remove the registrymodifications.xcu work here, suggest close this bug.
Comment 5 Ariel Constenla-Haile 2012-07-04 05:28:41 UTC
Reopening. The bug was resolved for the user, but we didn't find a fix.
Comment 6 Martin Phillips 2012-09-18 22:25:00 UTC
I was using the version before 3.4 without problems.  As soon as I upgraded to 3.4, I have been experiencing exactly the same crashes in both Calc and Writer as described in this thread.

Could someone please clarify exactly what I should do to registrymodifications.xcu to cure the problem, assuming that this file is also the culprit in my case too.
Comment 7 Ariel Constenla-Haile 2012-09-18 23:10:26 UTC
(In reply to comment #6)
> I was using the version before 3.4 without problems.  As soon as I upgraded
> to 3.4, I have been experiencing exactly the same crashes in both Calc and
> Writer as described in this thread.
> 
> Could someone please clarify exactly what I should do to
> registrymodifications.xcu to cure the problem, assuming that this file is
> also the culprit in my case too.

you have to close OpenOffice, including the quickstarter icon in the system tray, and then rename that file, so that it gets regenerated on the next start.
Comment 8 Martin Phillips 2012-09-19 22:08:30 UTC
>search for this file in your OpenOffice user folder in your Windows profile and rename it<

Apologies for being obtuse, but where is the Windows profile folder to be found?  I am running under XP.

Also, does it matter how I rename the file?  Should I leave the .xcu extension intact?
Comment 9 Ariel Constenla-Haile 2012-09-20 12:37:02 UTC
(In reply to comment #8)
> >search for this file in your OpenOffice user folder in your Windows profile and rename it<
> 
> Apologies for being obtuse, but where is the Windows profile folder to be
> found?  I am running under XP.


On my Windows XP it is under:

C:\Documents and Settings\ariel\Datos de programa\OpenOffice.org\3\user

Replace "ariel" with your user name, and "Datos de programa" is in English "Program data". 

Please note that "C:\Documents and Settings\YourName\Program data" is a hidden folder in Win XP, so enter the path directly on the Explorer, or select the option to also display hidden files.

> Also, does it matter how I rename the file?  Should I leave the .xcu
> extension intact?

You can rename it to registrymodifications.xcu.bak for example.

If this does not work, try renaming the whole directory:

C:\Documents and Settings\YourName\Program data\OpenOffice.org\3\user-old
Comment 10 Martin Phillips 2012-09-20 22:16:22 UTC
Thanks to your help, I was able to regenerate registrymodifications.xcu.  Unfortunately, this hasn't cured the problem for me, but it was worth a try.
Comment 11 Sidney Lichter 2012-10-09 19:37:04 UTC
Using version 3.4.0
After opening the spreadsheet, I clicked on HELP and entered the search criterion "delete rows". As soon as I clicked FIND I got this error.  My background is in mainframe programming, primarily in COBOL, with some assemblers added for flavor.

If you need it, I can send you a copy of the spreadsheet, which in my case is the source data for a mailing list.

I'd still like to know how to get rid of the rows that I no longer need (people who've died, moved with no forwarding address, have withdrawn from the organization, or no longer want to receive our mailings).
Comment 12 legacy370 2013-01-10 03:12:43 UTC
I am experiencing the exact same symptoms.  I have de-installed Open Office, totally removed c:\users\<myusername>\AppData\Roaming\OpenOffice.org, then reinstalled Open Office.  Same problem appears within 30 seconds of opening a spreadsheet.

I have found and deleted registrymodifications.xcu, only to have it reappear as the program crashes.

By the way, Gnumeric Spreadsheet works without a problem, on the same spreadsheets that cause Open Office to crash.

I should mention that Writer also crashes within seconds after opening, whether or not I am actively editing a document.
Comment 13 Paul 2013-03-16 18:39:29 UTC
Created attachment 80414 [details]
report.wer file created by windows

This is the report,wer file created by windows after the crash.
Comment 14 Paul 2013-03-16 18:41:20 UTC
When this happens to me, it is after a re-boot. If I try starting calc several times, it eventually does not fail with an unexpected error and stays up with no issues until the next time that I reboot. I am using Windows 7 Professional (64 bit) Service pack 1 on a Dell XPS with 8 GB of memory. My machine is up 24 X 7 and is not rebooted very often because I tend to leave work open so I can resume the next day.

When I acknowledge the Unexpected error alert, it does not close and I have to force it closed.

I tried renaming registrymodifcations.xcu. Now I get an empty alert that is marked as not responding whem it initially displays.

I noticed an event in the Windows Application Event log indicating a cross thread deadlock. This was on the application hang event after the alert appeared and became unresponsive.

I have attaching the report.wer created by one of the crashes.
Comment 15 doctorcz 2014-11-03 01:10:43 UTC
WOW!!! FUNTIONS OF MODULE RECOVERED !
i probe rename xcu file and "user" to  path rename to my actual username  on the profile.After start opening ods file autostarted wizard of migrate properties to file. After legally ending  wizzard is file  openable,and problem is o.k.
Comment 16 SiH 2019-12-09 15:25:10 UTC
Spreadsheet  just keeps crashing when I enter data in search box but it varies every so often, sometimes  till after its searched. It was OK in previous version.