Difference between revisions of "Documentation/FAQ/Calc/Formatting/I have a custom number format that I use, but Calc forgets it."
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Formatting
(New page: {{DISPLAYTITLE: I have a custom number format that I use, but Calc forgets it.}} <section begin=question/> '''I have a custom number format that I use, but Calc forgets it.''' <section en...) |
m |
||
| (One intermediate revision by the same user not shown) | |||
| Line 6: | Line 6: | ||
<section begin=answer/> | <section begin=answer/> | ||
| − | + | ||
For Calc to remember the preferred number formats, add them to a template: | For Calc to remember the preferred number formats, add them to a template: | ||
| − | # Create a new empty spreadsheet document or open an existing template by selecting | + | # Create a new empty spreadsheet document or open an existing template by selecting {{menu|File|Templates|Edit}} from the main menu |
# Add the number formats as required | # Add the number formats as required | ||
| − | # Select | + | # Select {{menu|File|Templates|Save}} from the main menu |
# Insert a name for the template and select a template category (e.g., '''My Templates''') | # Insert a name for the template and select a template category (e.g., '''My Templates''') | ||
| − | # Click | + | # Click {{button|OK}} to save the template |
To have them available with every newly created spreadsheet you need to make this template your default template: | To have them available with every newly created spreadsheet you need to make this template your default template: | ||
| − | # Select | + | # Select {{menu|File|Templates|Organize}} from the main menu |
# Select the template from the list of templates (double click the template categories to show all containing template files) | # Select the template from the list of templates (double click the template categories to show all containing template files) | ||
# Right-click the template file name and select '''Set as default template''' | # Right-click the template file name and select '''Set as default template''' | ||
| − | # Click Close | + | # Click {{button|Close}} |
<section end=answer/> | <section end=answer/> | ||
[[Category:Documentation/FAQ/Calc/Formatting]] | [[Category:Documentation/FAQ/Calc/Formatting]] | ||
Latest revision as of 14:52, 2 October 2021
I have a custom number format that I use, but Calc forgets it.
For Calc to remember the preferred number formats, add them to a template:
- Create a new empty spreadsheet document or open an existing template by selecting File → Templates → Edit from the main menu
- Add the number formats as required
- Select File → Templates → Save from the main menu
- Insert a name for the template and select a template category (e.g., My Templates)
- Click OK to save the template
To have them available with every newly created spreadsheet you need to make this template your default template:
- Select File → Templates → Organize from the main menu
- Select the template from the list of templates (double click the template categories to show all containing template files)
- Right-click the template file name and select Set as default template
- Click Close
