General discussion on OpenOffice Calc and its spreadsheets.
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,
- Posts: 32
- Joined: Tue Mar 25, 2014 6:18 am
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.
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