Replacing an Number Field with text as in your formula will have impact
on calculations like COUNT() or AVERAGE()
Also your formula doesn't take into account negative numbers
Suppressing the display of zeros in your Options works on your Display,
but it will not suppress your it when
you print or export as PDF. To Suppress the output of zero values you
can work with Conditional Formatting and
set the Cell Protection to "Hide when printing".
Working with number formatting like # only works with whole numbers but
still display a value 0.123 as .123
On 02/06/2020 00:13, Snapafun wrote:
Great suite - Thanks.
I love to hide the "0" value in cells yet to be populated and to do so
I use the =IF(Target Cell>0;Actual Formula;"") setup.
This works well for me upon the Target Cell being the result or a
manual entry.
However, this doesn't work when the Target Cell contains a formula. (
I appreciate that the formula setup as above is correct and that it
now recognizes that the Target Cell is populated so is ">0" - just
that viewed in real life - no actual value yet exists.)
Maybe there's a way of re-addressing the value "0" in the 1st part
though it would be nice for a private user to be able to keep their
formulas simple.
So - not necessary a fault or bug or anything at all - just a thought
in case it's possible.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
