Hi,
you can also format those cells using the user defined cell format # to
suppress so called leading zeroes in cells.
->format->cells->numbers->Format Code: #
Kind regards, Joost
Am 02.06.2020 um 00:51 schrieb David Robley:
There is an option to globally suppress display of zeros - see Tools |
Options | OpenOffice Calc | View and uncheck Zero Values in the Display
section.
Since you are not subscribed to this list you may not see all the
replies to your query. To subscribe to Apache OpenOffice mailing lists
go to http://openoffice.apache.org/mailing-lists.html
As a courtesy I have sent a copy of this reply to you as well as to the
mailing list. Do Not reply to me personally but just to the list at
<users@openoffice.apache.org> - replies to my personal email address
will be ignored.
On 2/6/20 7:43 am, 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.
Cheers
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
