Apache OpenOffice (AOO) Bugzilla – Issue 118903
Calc crash in recovery
Last modified: 2012-09-24 12:04:08 UTC
OOO330m20 (build: 9567) Calc crashed, then every successive execution of Calc crashed. If I opened Calc, by clicking my spreadsheet, it would attempt to recover my spreadsheet, then crash (either during recovery process, or just after). If I opened Calc directly (so default unnamed, empty spreadsheet was on screen, then as soon as I attempted to edit a cell, Calc would crash. Recovery would crash, whether it was recovering my spreadsheet, or the unnamed file. Ran Install "Repair" twice, then a full un-install > re-install. Crashes continued. Ran Norton scans (except full scan), with zero issues found. un-installed several old versions of programs and ran registry cleanup. Calc continued to crash. Finally, I opened Calc (directly) and then clicked FILE>NEW and selected Text Document. Write opened and worked properly, so I returned to the unnamed spreadsheet and it worked properly (can edit cells and save.) With Calc now working, I opened my spreadsheet and it is working correctly (open, edit, save, close, open...) As the crash trigger seems to be able to survive un-install and re-install of OpenOffice, maybe recovery needs a [Cancel With Prejudice!] option...?
When you have problems with document recovery please edit the following file and delete the respective items for the affected files (may differ on Windows): /home/<user>/.openoffice.org/3/user/registry/data/org/openoffice/Office/ Recovery.xcu (this "survives" a reinstall because the user installation is not deleted) For further questions regarding document recovery or crash guard please write to the user's forum as it fits better: http://support.openoffice.org/index.html The dialog itself is not perfect. There are already a few issues open that report an improvement. Due to this and because this issue is not reproducible I'll close it.
(The system is Vista SP2, running OO 3.4.1) How to reproduce: - Start Open Office Calc. - Save workspace as "CrashTest.ods" - From Task Manager kill Open Office (soffice.exe/bin -- one of each). This simulates a system crash/power loss/Win Update reboot. - Double click on the saved "CrashTest.ods" in Explorer. - OO puts up a message that recovery will occur -- allow it. - When the Calc window comes up, don't touch it -- just wait about 10 seconds. - Calc window closes and OO puts up a message that recovery will occur -- from now on the sequence will repeat. If the file is opened with Excel it will be reported as containing errors (which doesn't happen if recovery has not occurred this way). The "recovery" is corrupting the file. If this were just an occasional problem it would be one thing, but it's easily reproduced -- any "recovery" damages the ods file.