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

show empty cells for zero values

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
cdiesxm
Newbie
Newbie


Joined: 11 Dec 2006
Posts: 2

PostPosted: Mon Dec 11, 2006 9:18 am    Post subject: show empty cells for zero values Reply with quote

Hi,

I made the move from Excel, but just one thing now is different. It prints all my spreadsheets with zero value cells as 0.00. (they are in currency)

Excel did not display zero value cells. Now I have converted them all and removed Office software. What to do?

Thank you.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Dec 11, 2006 9:56 am    Post subject: Reply with quote

Just like Excel: Menu:Tools>Options>Calc>View:"Show zeroes"
It is a per-document-setting, so you may want to set up a customized default template.
Shift+F11, name it and save
File>Templates>Organize...
Pick your template
Button:"Command">Set Default
Now your template will be used whenever you hit Ctr+N in Calc or call File>New>Spreadsheet.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
cdiesxm
Newbie
Newbie


Joined: 11 Dec 2006
Posts: 2

PostPosted: Mon Dec 11, 2006 5:29 pm    Post subject: zero values in cells still displays Reply with quote

Thanks for your help. I tried that but it must have something to do with the import from xls.

I already had display zero unchecked but it still displayed 0.00.

However when I create template and do Ctrl-N the new template does not display zeros.
But I selected and pasted the entire spreadsheet into the newly created template and if I enter 0 in a cell it does not display, but when I Cntrl-A and paste into the blank spreadsheet it still displays zeros.

Any other ideas please?

THanks
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Dec 11, 2006 5:38 pm    Post subject: Reply with quote

If A1 shows 0.00 check out if it is a number or text.
Some options:
=ISNUMBER(A1)
=ISTEXT(A1)
=TYPE(A1) [1=number, 2=text]
=COUNTA(A1:A1000)-COUNT(A1:A1000) [returns the count difference between all cells having content and numeric cells]
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc 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