# Is it possible to suppress printing zeros?

It is possible to suppress zeros on screen but I cannot find a way of suppressing them for printing. Am I being thick?

edit retag close merge delete

I only see a way by using filters - If "zeros" are filtered then they are not printed. But, depending on the complexity of your sheet, this may not be a solution for you. As far as I can see "suppressing zero" is a "View"-only setting and printing doesn't inherit the setting.

( 2019-04-17 12:41:14 +0200 )edit

How do you "suppress zeros on screen"?
I suppose you deselected >Options>LibreOffice Calc>View>Display>Zero values. This is a global setting I would dissuade from, and actually it doesn't propagate to printing.

( 2019-04-17 14:18:22 +0200 )edit

Sort by » oldest newest most voted

You should generally display zeros. That's reasonable because zero actually is a number, and therefore is regarded as a number by the often needed functions COUNT(), AVERAGE(), and some more functions from the statistical group. If zeros are suppressed generally you may forget the fact that cells not displaying their zero values actually contain numbers, and unconsidered effects may occur.

If you want to suppress zero values for specific and well considered reasons, you can apply a CellStyle having defined a Numbers format appropriate for the purpose. You can assign such a cell style directly (by doubleclick on its name in the F11 window, or overlay it by Conditional Formatting. You can even apply it as a direct attribute though I would dissuade from this.

A typical NumberFormat code-string for the purpose would be General;-General;"" e.g. Such a semicolon separated list of format codes is applied to postive/negative/zero values in this order.

Zeros suppressed this way will not be printed.

more

Thanks - now I see a second way ;-)

( 2019-04-17 14:37:28 +0200 )edit

Thank you - as I thought. It could be useful so I will suggest it as an improvement.

more