Ask Your Question
0

Is it possible to suppress printing zeros?

asked 2019-04-17 11:59:55 +0200

Stewartry gravatar image

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 flag offensive close merge delete

Comments

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.

Opaque gravatar imageOpaque ( 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.
For alternatives see my answer.

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

3 Answers

Sort by » oldest newest most voted
3

answered 2019-04-17 14:31:54 +0200

Lupp gravatar image

updated 2019-04-17 14:38:20 +0200

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.

edit flag offensive delete link more

Comments

Thanks - now I see a second way ;-)

Opaque gravatar imageOpaque ( 2019-04-17 14:37:28 +0200 )edit
1

answered 2019-05-14 17:45:17 +0200

Groot gravatar image

Dunno why people make such a meal of this - it's really simple:

image description

image description

edit flag offensive delete link more
0

answered 2019-04-17 13:26:45 +0200

Stewartry gravatar image

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

edit flag offensive delete link more

Comments

Please don't post a comment as an answer. Use the "add a comment" tool for the purpose instead.

Lupp gravatar imageLupp ( 2019-04-17 14:32:56 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-04-17 11:59:55 +0200

Seen: 93 times

Last updated: May 14