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.
Possibly you have disabled displaying zero values in Options→LibreOffice Calc→View. 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 Format→Cells, 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.
Using General;-General; doesn’t nail the decimals to a fixed amount; note that the General keyword may be translated in your locale.
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.
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.