Frequently asked questions - Calc

From The Document Foundation Wiki
< Faq‎ | Calc
Jump to: navigation, search

How to avoid printing zero values

For the whole sheeet

Page styles allow you to fix this property.

Go to Format ▸ Page ▸ [tab] Sheet and uncheck Zero Values.

  • This command modifies the style applied to the current sheet (whether this is the default style or some other).
  • To modify a different style,
    1. display the styles window using Format ▸ Styles and formatting (or press F11);
    2. display the Page Styles tab;
    3. right-click on the style you want to modify and procede as described above.

These parameters will apply to all existing sheets with the modified style(s).

For a range of cells

The simplest way to define this parameter is as a cell style: either the Default style , or another style, for example a personalised one.

  1. Dislay the Cell styles in the Styles window.
  2. Right-click on the style to be modified.
  3. The Numbers tab allows you to define a personalised cell format. The numeric format code is in three parts: the first part applies to positive values, the second to negative values and the third to the value zero. You can therefore define a format of the type:
Standard;-Standard;#


These parameters will apply to all existing cells with this style.