How to set up Calc not to print zero values cells ?

General discussion on OpenOffice Calc and its spreadsheets.

How to set up Calc not to print zero values cells ?

Postby MikeLON » Mon Aug 04, 2014 10:47 am

Hello,

I created a spreadsheet with some cell having zero values using formulas.
In a print preview, those cells are shown empty, but when printing the spreadsheet the zero values are printed as 0.000 in all relevant cells.
How can I set up Calc to leave zero value cells empty when printing the spreadsheet ?

Thanks in Advance,
MikeLON
 
Posts: 32
Joined: Tue Mar 25, 2014 6:18 am

Re: How to set up Calc not to print zero values cells ?

Postby Elwood M. Walker » Mon Aug 04, 2014 11:23 am

Hi Everyone,

This only change the screen display of 0 value, not the printing.

Format > Page, Sheet (last tab)
uncheck "Zero value" in Print.
This setting is also used for PDF export.

Thanks,
Elwood M. Walker
 
Posts: 33
Joined: Mon Mar 24, 2014 6:09 am


Return to OpenOffice.org Calc

Who is online

Users browsing this forum: No registered users and 0 guests

cron