Page 1 of 1

User Defined Number Formats for cells - save 4 future use?

PostPosted: Wed Jun 18, 2008 3:21 pm
by amycaraballo
I have a custom format of '(###) ###-####' to format telephone numbers. I've named it telephone. But each time I open a new spreadsheet, the UDF format is not there and must be re-created.

How do I permanently save a UDF number format?

Thanks!
Amy

Re: User Defined Number Formats for cells - save 4 future use?

PostPosted: Wed Jun 18, 2008 3:45 pm
by Hagar Delest
Create a cell style and save it in your template: [Tutorial] Creating a new default template.

Thanks to add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.

Re: User Defined Number Formats for cells - save 4 future use?

PostPosted: Wed Jun 18, 2008 4:31 pm
by amycaraballo
Hagar de l'Est wrote:Create a cell style and save it in your template: [url=http://user.services.openoffice.org/en/forum/viewtopic.php?f=71&t=1161]
[Tutorial] Creating a new default template[/url].

Thanks to add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.


Thanks. But for some reason, I can't get an option to 'save as the default' template (see attached gif)

The file is saved as:
MySpreadsheet.ots
OpenDocument Spreadsheet Template

I'm using 2.41

Re: User Defined Number Formats for cells - save 4 future use?

PostPosted: Wed Jun 18, 2008 5:29 pm
by Hagar Delest
Browse from the left area (Templates).

Re: User Defined Number Formats for cells - save 4 future use?

PostPosted: Wed Jun 18, 2008 5:38 pm
by Villeroy
Hagar de l'Est wrote:Browse from the left area (Templates).

... pick your template and then call "Set default" from the "Commands" button (the button contains a menu).

Re: User Defined Number Formats for cells - save 4 future use?

PostPosted: Wed Jun 18, 2008 6:14 pm
by Hagar Delest
It's also available from context menu:
Template.png
Template.png (7.58 KiB) Viewed 1535 times