[Libreoffice-bugs] [Bug 125860] FILEOPEN XLSX: separate options for display/print Zero values

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125860

--- Comment #4 from Tobias Burnus <tobias.burnus at physik.fu-berlin.de> ---
(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
> values.

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


EXPECTED:
* 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.


For consideration:

* 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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190612/1ba90ad3/attachment.html>