Ask Your Question

How I suppress zero values in spreadsheet

asked 2018-07-12 16:12:16 +0100

Glyn-e gravatar image

I have a spreadsheet which looks good on t.he screen but prInts all zero values. I would like zero values not to be printed at all. I'm sure it's simple but just can't see how to do it.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-07-12 16:31:56 +0100

Possibly you have disabled displaying zero values in OptionsLibreOffice CalcView. This option does hide those values on screen - but does not affect printing - this is just a visual aid.

To properly hide zero values, one way is to use a proper format string. Preferably in corresponding cell style; or just simply for selected cells, using menu FormatCells, Numbers tab. You may use something like this (of course, tuned to use your locale's decimal/thousand separators and required number of digits): 0,00;-0,00; - nothing after the second semicolon tells that the zero values are to not be displayed.

edit flag offensive delete link more



Using General;-General; doesn't nail the decimals to a fixed amount; note that the General keyword may be translated in your locale.

erAck gravatar imageerAck ( 2018-07-12 17:34:39 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-12 16:12:16 +0100

Seen: 3,175 times

Last updated: Jul 12 '18