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

Discuss the spreadsheet application

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

Postby amycaraballo » 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
OOo 2.4.X on Ms Windows XP
amycaraballo
 
Posts: 2
Joined: Wed Jun 18, 2008 3:17 pm

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

Postby Hagar Delest » 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.
LibreOffice 7.0.3 on Xubuntu 20.10 and LibreOffice 6.4.6 (portable) on Windows 10.
User avatar
Hagar Delest
Moderator
 
Posts: 29255
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

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

Postby amycaraballo » 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
Attachments
Capture1.gif
Capture1.gif (8.03 KiB) Viewed 1538 times
amycaraballo
 
Posts: 2
Joined: Wed Jun 18, 2008 3:17 pm

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

Postby Hagar Delest » Wed Jun 18, 2008 5:29 pm

Browse from the left area (Templates).
LibreOffice 7.0.3 on Xubuntu 20.10 and LibreOffice 6.4.6 (portable) on Windows 10.
User avatar
Hagar Delest
Moderator
 
Posts: 29255
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

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

Postby Villeroy » 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).
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 29107
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Postby Hagar Delest » Wed Jun 18, 2008 6:14 pm

It's also available from context menu:
Template.png
Template.png (7.58 KiB) Viewed 1531 times
LibreOffice 7.0.3 on Xubuntu 20.10 and LibreOffice 6.4.6 (portable) on Windows 10.
User avatar
Hagar Delest
Moderator
 
Posts: 29255
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Calc

Who is online

Users browsing this forum: No registered users and 22 guests