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.
LO 6.4.6 on Xubuntu 20.04 and Windows 10.
User avatar
Hagar Delest
Moderator
 
Posts: 29079
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 1482 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).
LO 6.4.6 on Xubuntu 20.04 and Windows 10.
User avatar
Hagar Delest
Moderator
 
Posts: 29079
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: 28846
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 1475 times
LO 6.4.6 on Xubuntu 20.04 and Windows 10.
User avatar
Hagar Delest
Moderator
 
Posts: 29079
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Calc

Who is online

Users browsing this forum: No registered users and 24 guests