Apache OpenOffice (AOO) Bugzilla – Issue 8640
Save as .xls writes incorrect cell format
Last modified: 2013-08-07 15:14:58 UTC
A cell that contains a formula such as =IF(C8="";"";IF(C8=$D$5;0;C8)), with Category=Number, Format=General, is written out as an .xls with Category=General if the source cell C8 contains a value, but Category=Text if C8 does not contain a value. This leads to any further calculations that reference the cell being incorrect, as Text cells are not considered to be numbers. I had previously been adding comments to Issue 5658, but I now believe that this is a separate issue with the Save As Excel 97 code. See the prh_demo.sxc attachment. If you save this as Excel, cell D7 remains as numeric, but D8 changes to Text. If you then overtype B8 and D8, then E8 miscalculates (overtype B7 and D7 with the same values to see the correct result in E7).
Created attachment 3306 [details] Demo spreadsheet for Save As Excel cell format problem
Very easy to reproduce: In a new spreadsheet, type ="", and save to Excel.
started
target->OOo1.1beta
Accepting ownership of thois issue. Thanks to Daniel the proposed fix turned out to be relatively simple.
Created attachment 4327 [details] proposed patch
Checked in this fix today
re-open to assign to QA
re-assigning to QA
re-setting to "fixed"
verified on cws calc06 using Windows and Solaris
found integrated on Solaris, Linux and Windows using srx644m10s1
*** Issue 13814 has been marked as a duplicate of this issue. ***