Created attachment 152106 [details]
Example XLSX file from Excel 2007 SP 3
That's with LO 126.96.36.199 on 32bit Windows.
The following Excel sheet shows no "0" when viewed in Excel 2007 SP 3 and LibreOffice, but when printing it in LibreOffice (e.g. print preview, PDF export etc.) the "0" do appear.
EXPECTED: Consistent result - i.e. no 0.
Created attachment 152107 [details]
Screenshot - comparing LibreOffice Calc and Excel 2007 - with normal view and print preview
When you go to format page and in tab sheet uncheck zero values, you will have no zero when printing.
And a second place where you can uncheck zero values is in tools => option => libreoffice calc => view
So for me its WFM and not a bug
"Zero values" options after opening *.xlsx are:
- Menu "Tools/Options.../LibreOffice Calc/View
Display [ ] Zero values
- Menu "Format/Page.../Sheet" (PageStyle_Gruppe 3")
Print [X] Zero values
result: LO shows 0 in print preview but nothing in normal view
btw: not sure if excel has a separate option for displaying/printing zero values.
(In reply to Oliver Brinzing from comment #3)
> "Zero values" options after opening *.xlsx are:
> - Menu "Tools/Options.../LibreOffice Calc/View
> Display [ ] Zero values
> - Menu "Format/Page.../Sheet" (PageStyle_Gruppe 3")
> Print [X] Zero values
> result: LO shows 0 in print preview but nothing in normal view
> btw: not sure if excel has a separate option for displaying/printing zero
The PowerPoint file (.xlsx) contains for that sheet ("xl/worksheets/sheet1.xml"):
<sheetView showZeros="0" tabSelected="1" zoomScale="85"
zoomScaleNormal="85" zoomScalePageLayoutView="80" workbookViewId="0">
My understanding is that in Excel there is only one common setting for printing/PDF export and viewing - and that this setting is per sheet.
(I think one common setting makes sense as you get what you see.)
Cf. also https://support.office.com/en-us/article/display-or-hide-zero-values-3ec7a433-46b8-4516-8085-a00e9e476b03
* For sure, on IMPORT the per-sheet setting of the PowerPoint file ("showZeros") should properly set the page setting in LibreOffice as there is a one-to-one match.
* Tools/Options: Make it clearer which options are the setup for this LibreOffice installation and which are for the document currently open (and saved alongside with the document).
* Consider for instance to have a three-way choice in Tools/Options: Show zero, do not show zero, use page-setting also for viewing on the screen.