Bug 63367 - PRINTING: Unticked option "Display Zero Values" ignored in printing/exporting to PDF
Summary: PRINTING: Unticked option "Display Zero Values" ignored in printing/exporting...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other Linux (All)
: medium minor
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2013-04-10 09:54 UTC by Callegar
Modified: 2013-09-24 21:31 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Callegar 2013-04-10 09:54:37 UTC
Problem description: 

Bug manifests when a cell is the result of a mathematical computation, say =+I19*A19*(H19+1)

If the referenced cells are emtpy, then the cell itself looks empty.
However, if the cell has a currency format, when printing or exporting to PDF the cell is not anymore empty as it should, but contains something line "€ 0,00"

Operating System: Ubuntu
Version: release
Comment 1 billhook 2013-04-11 04:03:08 UTC
LO Windows 7 Professional

I tried to reproduce this, by typing in the formula you gave as an example, in a blank sheet.
On my system, the cell displayed on the screen is not blank, but contains the text that you describe as only appearing when printed.

Perhaps the bug is that the value is not appearing when editing the document, when it should??
Comment 2 Callegar 2013-04-12 09:05:25 UTC
My fault,

I forgot to mention that the bug is present when you have "Display Zero Values" unchecked in the options. I.e.,

Options -> Calc -> View -> Display Section -> Zero Values

This option effectively disables the display of zero values, but does not disable it in printing or exporting to pdf. Changing bug title accordingly.
Comment 3 Joel Madero 2013-05-29 21:58:32 UTC
Duplicate of an ongoing "bug" that is being discussed:

*** This bug has been marked as a duplicate of bug 51856 ***
Comment 4 Callegar 2013-05-30 08:08:34 UTC
Unhappy about duplicate status.

My issue is not that the option not to print zeros is hard to find in the print menu, or that it is not persistent.

My issue is that the system is inconsistent. It may not show the zeros when editing and then print them. When you ask not to see the zeros, IMHO by default the zeros should not be printed either.
Comment 5 Joel Madero 2013-05-30 13:53:12 UTC
If we ever make a mistake, feel free to undo our change ;) We're all human. Removed duplicate status - will investigate further. Thanks!
Comment 6 Callegar 2013-05-30 14:05:30 UTC
Thanks for removing duplicate and for the advice. I didn't know if removing the duplicate myself was OK!
Comment 7 Joel Madero 2013-05-30 14:20:34 UTC
It is okay as long as you justify the change :) Which you seem to have done
Comment 8 ign_christian 2013-05-31 10:42:13 UTC
Goto menu Format > Page > Sheet > unchek Zero values under pane "Print"
And then check with Page Preview

Please change status to: RESOLVED NOTABUG if you agree
Comment 9 Callegar 2013-05-31 11:49:17 UTC
It is not that important and I can forget about this bug. But again... the bug (which is a minor usability bug) is about interface consistency.

Why are there 2 different places where one decides where to have or not visible zeros?

One is in tools->options->calc-view (and affects display)
Another one is in format->page->sheet (and affects print and export to pdf)

IMHO this is causing confusion in the users (at least in my and some users I used to prepare templates for), because:

1) When a document displays in some way, users expect it to print in the same way. Aren't they using a wysiwyg software just for that?  It is confusing that they have no zeros in display and then zeros suddendly appear when they print.

2) These options are (correctly) buried under a 3 level hierarchy. Unfortunately this makes them not exactly easy to find (also due to the fact that the first levels of the hierarchy are quite different). Thus, when the users have their systems not showing the zeros and then get funny printed documents filled with zeros, they may get frustrated before finding what to do.

I wonder if there a reason why this needs to be selectable in two different places in this way? I can think of cases where one may want to see zeros and not to print them (because in editing one may want to know if a cell is empty or not), but I really cannot figure out a case where one may want to print the zeros but not to display them.
Comment 10 Joel Madero 2013-09-24 21:31:24 UTC
This is not a bug - despite perhaps being a little confusing it's designed and behaving as expected.

One could easily argue that there are times when you want to not see 0's on the screen but when you print you do OR that you want to see 0's on the screen but not when you print.

For the case that you said you can't imagine why you'd want it. You could argue that on screen it gets quite cluttered when you have a lot of 0's but once you print you are intending for the audience to see the 0's, even if it's cluttered the 0's mean something that you want your audience to see.

Fundamentally these are two different options, combining them takes away usability and I am almost guarantee that if we combined them we'd have users unhappy with stripping them of the option(s).