OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

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

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> Setup and Troubleshooting
View previous topic :: View next topic  
Author Message
Deliz
General User
General User


Joined: 23 Aug 2005
Posts: 11

PostPosted: Tue Aug 23, 2005 9:01 am    Post subject: Problem with OOo, Please help!!!! (Spreadsheet) Reply with quote

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.
Back to top
View user's profile Send private message
probe1
Moderator
Moderator


Joined: 18 Aug 2004
Posts: 2560
Location: Chonburi Thailand Asia

PostPosted: Tue Aug 23, 2005 9:37 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website
Deliz
General User
General User


Joined: 23 Aug 2005
Posts: 11

PostPosted: Tue Aug 23, 2005 9:49 am    Post subject: Thanks Reply with quote

Thanks going to try it out now, hope it works! Smile
Back to top
View user's profile Send private message
Deliz
General User
General User


Joined: 23 Aug 2005
Posts: 11

PostPosted: Tue Aug 23, 2005 9:52 am    Post subject: Reply with quote

probe1 wrote:
Tools->Options...->Spreadsheet->View->Show null values

(hope i got the right translation)


I don't see the option for the "null values"
Back to top
View user's profile Send private message
8daysaweek.co.uk
Super User
Super User


Joined: 29 Nov 2003
Posts: 2130
Location: UK

PostPosted: Tue Aug 23, 2005 10:10 am    Post subject: Reply with quote

Hi Deliz,

I have Zero values, do you?

WinXP Pro / OOo 1.1.4

BFN Smile,
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site
Back to top
View user's profile Send private message Visit poster's website AIM Address
Deliz
General User
General User


Joined: 23 Aug 2005
Posts: 11

PostPosted: Tue Aug 23, 2005 10:15 am    Post subject: Zero Values Reply with quote

I got em, and thanks for the help. I got it figured out now. Smile
Back to top
View user's profile Send private message
Deliz
General User
General User


Joined: 23 Aug 2005
Posts: 11

PostPosted: Tue Aug 23, 2005 10:51 am    Post subject: Problems with printing out spreadsheet. Reply with quote

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.
Back to top
View user's profile Send private message
probe1
Moderator
Moderator


Joined: 18 Aug 2004
Posts: 2560
Location: Chonburi Thailand Asia

PostPosted: Tue Aug 23, 2005 11:12 am    Post subject: Reply with quote

for printing (not printing zeros, to be precise) you have to use a formular like
Code:
=If( (SUM(D7*H7)) > 0; D7*H7; "")


HTH
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs
Back to top
View user's profile Send private message Visit poster's website
Deliz
General User
General User


Joined: 23 Aug 2005
Posts: 11

PostPosted: Tue Aug 23, 2005 11:19 am    Post subject: Thanks Again Reply with quote

I would like to thank you all for helping me with my OOo Problems, my spreadsheet is SUPER MODE now thanks to you all. Smile Smile Smile
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> Setup and Troubleshooting All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group