I have hidden zero values in Libreoffice Calc, but there are occasions when I need to show a zero value. Is there any way that I can do this please?
Welcome!
How do you define these special cases? Is it some kind of data-driven condition or just a manual choice?
1 Like
It is basically putting a sum received against a sum owed. In Excel you can configure the cell to show the zero when the two figures match, but it doesn’t seem to work with LibreOffice. I hasten to add, I have only just gone over to LibreOffice so I know almost nothing about it.
You could show a text like
IF ( condition ; " 0"; 0)
mathematically simple: n – n = 0, the value in cell [A1] is equal to the value in cell [A2]
This is very true. However, I have hidden zero values, but in this instance I want a zero to show
For the formula =A1 – B1 = 0 (or simpler, =A1=B1), the result of “true” is 1, not 0.
[A1]-[A2]+0.000001, with reduction of any decimal place to zero, if you want to calculate with that numeral, you have to correct it with –0.000001