Apache OpenOffice Community Forum

Posted: **Wed Jun 18, 2008 3:21 pm**

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

Posted: **Wed Jun 18, 2008 3:45 pm**

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.

Posted: **Wed Jun 18, 2008 4:31 pm**

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

Posted: **Wed Jun 18, 2008 5:29 pm**

Browse from the left area (Templates).

Posted: **Wed Jun 18, 2008 5:38 pm**

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).

Posted: **Wed Jun 18, 2008 6:14 pm**

It's also available from context menu:

: Template.png (7.58 KiB) Viewed 1535 times

Apache OpenOffice Community Forum

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

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

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

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

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

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

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