Issue 106135 - Zero results do not appear when workbook is opened.
Summary: Zero results do not appear when workbook is opened.
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.1.1
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-10-21 11:31 UTC by cassioneri
Modified: 2013-03-11 14:59 UTC (History)
2 users (show)

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


Attachments
Zero resulting from formulas don't appear when this file is opened. (6.71 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-10-21 11:34 UTC, cassioneri
no flags Details
Patch to solve this issue. To be applied against changeset bec9b2b2628f (child of tag DEV300_m64). (730 bytes, text/plain)
2009-11-22 20:05 UTC, cassioneri
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description cassioneri 2009-10-21 11:31:31 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.
Comment 1 cassioneri 2009-10-21 11:34:09 UTC
Created attachment 65505 [details]
Zero resulting from formulas don't appear when this file is opened.
Comment 2 jbf.faure 2009-11-01 10:20:16 UTC
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.
Comment 3 cassioneri 2009-11-22 20:05:27 UTC
Created attachment 66266 [details]
Patch to solve this issue. To be applied against changeset bec9b2b2628f (child of tag DEV300_m64).
Comment 4 cassioneri 2009-12-12 09:03:40 UTC
Change issue type to PATCH.
Comment 5 Rob Weir 2013-03-11 14:59:38 UTC
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