Apache OpenOffice (AOO) Bugzilla – Issue 65690
Calc crashes when saving this document
Last modified: 2013-08-07 15:14:17 UTC
Load the document, when you are prompted, select "enable macros", you are in the first tab ("numero") and enter a number in the cell that has 42 (i.e. 43... is not important). Then close calc letting it save the document. You will see the progress bar running while saving, then calc crashes. I've found the same problem with RC1 and RC2, both under GNU/Linux and Windows2000, using the Pavel's builds. The m165 build1 does not suffer for it (nor previous versions, as far as I can tell).
Created attachment 36653 [details] Calc file that crashes on save
Confirmed crash in my builds. Anyone to confirm this in Sun builds too?
Also confirmed with Pavel's build of m170.
It's because of the name "RiportaNomeCondominio" which has no content. If you remove it, the file is saved without problems.
As far as I can see, such empty names can only be created using the API, and removing them allows the file to be saved, so after consultation with QA, we'll fix this only for 2.0.4.
This file was converted from Excel 2000 (and the macro re-wrote in starbasic). Wondering if the "dead" name is something you can easely produce with Excel and so can hurt OOo when dealing with Excel files as well (and this would be more harming than a strange name produced by API, of course). In any case, previous version did not crashed, and having Calc be more "error proof" again would be a good thing. Home mine is a rare case, otherwise a lot of people could complain about Calc 2.0.3 being broken...
Do you still have the Excel file from which this was converted?
I have, but can't upload because I no longer have Excel and so I can't remove private data with the native application (Excel). Anywhay, I've checked, and the original .xls file has that name with this reference: $#RIF!.$A$1 But this has been preserved during conversion (.ods produced with OOo 2.0.3 has also), so I've no idea how it can have been removed. It could be that previous OOo had problems with that, so I'm facing an old OOo issue (already happend to me, see issue 63735).
Fixed on CWS "calcsavecrash". Note: I could create a crashing document from Excel import, but only if a name contains only an error code (quite an unusual case).
Reassigning to QA for verification. re-open issue and reassign to oc@openoffice.org
reassign to oc@openoffice.org
reset resolution to FIXED
verified in internal build cws_calcsavecrash
*** Issue 66974 has been marked as a duplicate of this issue. ***
*** Issue 67009 has been marked as a duplicate of this issue. ***
*** Issue 66941 has been marked as a duplicate of this issue. ***
closed because fix available in src680_m177
*** Issue 67475 has been marked as a duplicate of this issue. ***
*** Issue 68197 has been marked as a duplicate of this issue. ***
*** Issue 69124 has been marked as a duplicate of this issue. ***
*** Issue 70052 has been marked as a duplicate of this issue. ***
*** Issue 70063 has been marked as a duplicate of this issue. ***