Problem with OOo, Please help!!!! (Spreadsheet)

[Deliz]

I have a spreadsheet, and have the code =SUM(A7*D7) in Cell E7 and it shows $0.00 by default until you add your figures in cells A7 and D7.
My question is that I don't want the $0.00 to show until I have ented a number/figure into Cell A7 and D7. How do I make it invisible until the information has been added. I am using OOo Version 1.1.3, thanks.

[probe1]

Tools->Options...->Spreadsheet->View->Show null values

(hope i got the right translation)
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs

[Deliz]

Thanks going to try it out now, hope it works!

[Deliz]

[8daysaweek.co.uk]

Hi Deliz,

I have Zero values, do you?

WinXP Pro / OOo 1.1.4

BFN ,
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site

[Deliz]

I got em, and thanks for the help. I got it figured out now.

[Deliz]

I unchecked the Zero Vaules in the spreadsheet options, and it seemed to fix the problem, but when I print the spreadsheet the $0.00's still show even when a figure was not placed in the cell. How do I make it to where it keeps the $0.00's from printing out on Paper.

[probe1]

for printing (not printing zeros, to be precise) you have to use a formular like

[Deliz]

I would like to thank you all for helping me with my OOo Problems, my spreadsheet is SUPER MODE now thanks to you all.