Customise Openoffice Calc cells

If you have a long Openoffice Calc spreadsheet with lots of zero values, you might not necessarily want to see them. It is possible to set Calc so that it leaves cells as blank if they contain a zero. This can either be set for on screen only, printing only or both.

To remove the zeros from the screen, click on the Tools menu and then on Options. Left-click on the small plus sign next the entry for Openoffice.org Calc and then on the View option. Left-click in the box labelled Zero values so that the tick disappears. Click on OK to save the change.

To stop the zeros from printing, click on the Format menu and then Page. Click on the Sheet tab and then in the box labelled Zero values. Click on OK to save the change. The printing setting only applies to the current document.
Ufi ­ OpenOffice Help TNT blog