Bug 50840 - Not showing calc cell with "0" in exported pdf.
Summary: Not showing calc cell with "0" in exported pdf.
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Printing and PDF export (show other bugs)
(earliest affected)
3.5.4 release
Hardware: x86 (IA32) All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2012-06-07 08:55 UTC by azatom
Modified: 2014-10-27 12:02 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:

saved with msexcel10, lo opens correctly, error in lo pdf export (2.71 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-06-07 08:55 UTC, azatom

Note You need to log in before you can comment on or make changes to this bug.
Description azatom 2012-06-07 08:55:48 UTC
Created attachment 62727 [details]
saved with msexcel10, lo opens correctly, error in lo pdf export

Steps to reproduce:

1a. Open my attached version.
1b. OR generate ods with MS Excel: simple enter '0' (just a zero character) to a cell, (I entered A1:1, B1:0, C1:2 just to see where it should be look for the 0), save it.
2. Open with libreoffice, the zero shows correctly.
3. Export pdf (or pdf/a-1a).
4. Open pdf with different viewers, the zero is not there!

What should happend:
The zero must be in the pdf.

Reproducable with:

Libre office 3.5.3 linux and 3.5.4 windows versions, the exported pdf viewed with different viewers/platforms. MS Excel 2010.

I do not know it is the pdf export's or libreoffice's error, but i think it is NOT the  msoffice's error. I looked in the ods as zip file, it is pretty simple, very similar to what I generated with the same steps with libreoffice. For example the '1' and '2' have exactly the same context as the '0'.
Comment 1 azatom 2012-06-07 11:09:45 UTC
1. MS excel opens the attached file with error because I deleted manually the "creator" from the .ods/meta.xml, otherwise this file works the same before this editing.

2. Ms Excel print to xps and save to pdf SHOWS the "0" (zero character), just like the libreoffice on the screen.

3. In the libreoffice the page preview NOT shows the 0, just like the .ods/Thumbnails/thumbnail.png what is generated by the msoffice.

I thought it may be some settings what I did not know about, so it is something default behaviour not a bug, but in that case why prints it the ms and why not the libre?
Comment 2 bfoman (inactive) 2012-06-21 06:17:55 UTC
Confirmed with:
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit

Generated PDF doesn't contain row with O value. Print preview neither.
Comment 3 bfoman (inactive) 2013-01-09 11:48:27 UTC
Confirmed with:
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit

Still an issue. Marking as NEW.
Comment 4 GerardF 2013-01-10 10:38:16 UTC
Format > Page, sheet tab : print zero value is unchecked.
I do not have Excel and I don't know if Excel manage this kind of settings and in case of they do, where ?

Have a look at your options in MS-Excel.
Comment 5 reportingbugs100 2014-10-27 12:02:12 UTC
I have just experienced this with a document that was created in LO, edited in MS Excel then reopened in LO. It looks like MS Excel has either changed the value of Format > Page, sheet tab : print zero value, or just doesn't respect the original value in the ods file.

So the bug is either in MS Excel ods input/output or that it is the default behaviour of MS Excel when dealing with 0 value cells and printing