I have a custom number format that I use, but Calc forgets it.

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Formatting
Jump to: navigation, search


I have a custom number format that I use, but Calc forgets it.


2.x

For Calc to remember the preferred number formats, add them to a template:

  1. Create a new empty spreadsheet document or open an existing template by selecting File - Templates - Edit from the main menu
  2. Add the number formats as required
  3. Select File - Templates - Save from the main menu
  4. Insert a name for the template and select a template category (e.g., My Templates)
  5. Click OK to save the template

To have them available with every newly created spreadsheet you need to make this template your default template:

  1. Select File - Templates - Organize from the main menu
  2. Select the template from the list of templates (double click the template categories to show all containing template files)
  3. Right-click the template file name and select Set as default template
  4. Click Close


Personal tools