Apache OpenOffice (AOO) Bugzilla – Issue 106135
Zero results do not appear when workbook is opened.
Last modified: 2013-03-11 14:59:38 UTC
Same issue for OOo 3.0.0 (OOO300m9) running on Linux. When you save a workbook, zeros values are not saved if they are formula results. This is not a problem when "Tools / Cell Contents / AutoCalculate" is since, when oppening the workbook, formulas are recalculated and their results are shown. However, if "AutoCalculate" is off recalculation doesn't happen and zeros are left blank (even for "Tools / Options / OpenOffice.org Calc / View / Zero values" checked). In attachment an example workbook. A zero appears on A1 because it's not a formula. Zeros should appear in cells A2, A3, A4 and A5 but they don't. Press F9 to force calculation and you will see all zero values. I hacked the workbook file to get more information. In content.xml we see that if a cell contains a formula whose result is zero, then 'table:table-cell' element doesn't have 'office:value' and 'office:value-type' attributes and its 'text:p' element is empty. I've manually included 'office:value' and 'office:value-type' (assigned to "float") and 'text:p' (containning 0) but it doesn't help unless 'office:value' is different from 0 (but in this case we see a wrong value when we open the workbook). I guess this is both an open-import and a save-export issue.
Created attachment 65505 [details] Zero resulting from formulas don't appear when this file is opened.
I confirm the problem with OOo 3.1.1 (vanilla FR/US) on Ubuntu 8.04 and with OOO320_m3. If I force Calc to recalculate by pressing F9, zeros appear in A2:A5. Then if I save the file under another name, close and reload this new file, cells A2:A5 seem to be empty, which is not user friendly.
Created attachment 66266 [details] Patch to solve this issue. To be applied against changeset bec9b2b2628f (child of tag DEV300_m64).
Change issue type to PATCH.
I'm adding this comment to all open issues with Issue Type == PATCH. We have 220 such issues, many of them quite old. I apologize for that. We need your help in prioritizing which patches should be integrated into our next release, Apache OpenOffice 4.0. If you have submitted a patch and think it is applicable for AOO 4.0, please respond with a comment to let us know. On the other hand, if the patch is no longer relevant, please let us know that as well. If you have any general questions or want to discuss this further, please send a note to our dev mailing list: dev@openoffice.apache.org Thanks! -Rob