Ask Your Question
1

How I suppress zero values in spreadsheet [closed]

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

Glyn-e gravatar image

updated 2020-08-02 02:07:53 +0200

Alex Kemp 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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-02 02:08:01.065226

2 Answers

Sort by » oldest newest most voted
1

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

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

Comments

1

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 +0200 )edit
0

answered 2020-07-18 23:07:28 +0200

Glake gravatar image

updated 2020-07-18 23:40:21 +0200

Lupp gravatar image

I was trying to avoid entering an equation here if there was a setting. No.
From the time I got Excel on a floppy, when i want to print out values and exclude Zeros, I have used this: Assume I have values that are from a SUM() and may have values or nothing. To show/print values from a column sum that are Non-Zero:

=if(SUM(A1:A20)=0,"",SUM(A1:A20))

where "" are double quotes to fill the cell with a Null-string.

edit flag offensive delete link more

Comments

Slightly edited for better readability.
Cannot understand the post clearly anyway.
Valid zero results should also be shown. Replacing them conditionally with empty strings will afflict some accumulating or statistical functions. In addition it will casue errors with formulas trying to calculate somthing by ordinary arithmetics referring to these results.
Where these effects not are expectable, tehe formula as given will double the amount of needed calculations in the "standard" case.

Lupp gravatar imageLupp ( 2020-07-18 23:41:17 +0200 )edit

Question Tools

1 follower

Stats

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

Seen: 4,252 times

Last updated: Jul 18