OpenOffice.org Help TNT: Tips'n'Tricks that somehow didn't make it to the help (yet).

In OpenOffice.org Calc, you sometimes have long lists of values, most of them are zero values. You don't want to see all those "0" cells. You want to see only the valuable values that differ from zero.

Two settings exist that suppress the zero values: one setting is for the on screen view only, and the other setting is for printing only.

To suppress zero values on screen

1. Open a Calc document.

2. Choose Tools – Options – OpenOffice.org Calc – View.

3. Set or reset the Zero values checkbox.

To suppress zero values when printing

1. Open the Calc document.

   Yes, this setting is for the current document only.

2. Choose Format – Page.

3. Open the Sheet tab page.

4. Set or reset the Zero values checkbox.