Printing or Not of Zero Values in Calc

[Irelandshope]

Firstly I would like to say that I am a recent Mac switcher and loving it. I have always used MS Office and when I moved to the Mac I tried out the trial version of MS Office for the Mac. It was truly horrible, I cant believe its the No 1 selling piece of Mac software. It was really buggy and crashed quite often.

I have now been using Neooffice for around a month and I love it. It's very stable, hasn't crashed once and does everything very nicely. So congratulations Neooffice team nice work.

The question I have concerns not printing of Zero values in Calc. I have a spreadsheet template with lots of formula's but not all of them are used for each job. In preferences I have turned of Zero Values so that I dont see them on screen. The do still show up when printing so I went to format/page/sheet and unchecked Zero Values in the print section. Thats worked great no Zero Values where printed.

However if I close the spreadsheet when I reopen this box is checked again so I need to go through format/page/sheet and uncheck it again. Is there anyway to uncheck this option and have it be persistent after the application is quit and restarted.

Hope someone can offer a suggestion.
Thanks in advance
Stephen

[revsmitty]

Stephen,

Welcome to NeoOffice and the Trinity Forums.

When I uncheck the Print Zero Values box in Format>Page and then SAVE the document it stays unchecked when I quit Neo and then restart and open that document.

If you want to make this the default behavior for new Neo Spreadsheets then you have to create a new spreadsheet, uncheck the Print Zero Values and save the blank document as a template gving it whatever name you choose. The easiest way is to go to File>Templates>Save.

After you have saved it as a template Then you have to:
1 Choose File>Templates>Organize
2. Navigate to the place the blank template you just created. It should be located in the My Templates Folder.
3. Select the blank spreadsheet template and then choose the Commands button on the right hand side of the screen.
4. From the list that pops up find and click on Set as Default Template.

Now everytime you open a new spreadsheet this will be the default page format.

Hope this helps!

Galen

[Irelandshope]

Many thanks for your response.

If I keep the template in .stc format the setting sticks fine. When I save the finished spreadsheet out to .xls format the setting sticks while the spreadsheet remains open. However when I close it and reopen the box is checked again. I presume this setting cannot be retained in the .xls format.

Is this correct or is there any other way to suppress zero values being printed in .xls format.

Unfortunately I work in a windows shop and they only use .xls.

Thanks in advance
Stephen

[ovvldc]

I do conditional formatting: if cell value = 0 -> font colour = white

-Oz

[Samwise]

[Irelandshope]