Ops, I didn't know that! Thanks for the info! Might be useful!
Is that a global setting? If I set it to not display zero values, I will
probably want that setting to follow the spreadsheet rather than my
installation of OpenOffice, so when I send the file to my friend, the file will
look exactly the same on his computer as it did on mine. I didn't try it yet,
maybe I should before writing this reply... ;D
Johnny
Den 2006-01-12 14:58:03 skrev Eike Rathke <[EMAIL PROTECTED]>:
Hi Johnny.1966,
On Thu, Jan 12, 2006 at 10:50:38 +0100, Johnny.1966 wrote:
If you don't want the column K to show zeroes when nothing is entered in
the corresponding I and J cells, instead of entering =I1*J1, enter
something like =IF(OR(I1="";J1="");"";I1*J1)
A better solution is to disable Tools.Options.Calc.View, group Display,
checkbox "Zero values".
If for any reason zero values are to be displayed in other places of the
same document, disabling the display of zero values is also possible by
applying a number format similar to
0;-0;;
Note the empty third subformat for zero.
Eike
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
