Ask Your Question
1

QUESTION: How to store user defined number format for future use [closed]

asked 2013-06-12 11:22:51 +0200

Paijo gravatar image

I make a number format that doesn't exist in standard LO Calc number format. I often use this format, and often used on most files.

Is there a way to store my "user defined number format" so every time I create a new file, that my number format appear on number format list?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-02 04:57:37.124183

Comments

1

Maybe you can try to set up format number in blank document, save it as template, set up it as default template so every time you run Calc your number format will be loaded. And you can try to save it in Template folder (home/your name/templates) so you can create new file within Files with right click.

Ljiljan gravatar imageLjiljan ( 2013-06-12 14:17:56 +0200 )edit

@Ljiljan, can you please post your comment in an answer so it can be marked as correct? I believe a template containing the required cell style (with required user format) is the recommended method. Styles in templates is the general approach to obtaining required formatting all types of document.

oweng gravatar imageoweng ( 2013-06-13 08:42:23 +0200 )edit

ok, I did it... thanks.

Ljiljan gravatar imageLjiljan ( 2013-06-13 10:24:18 +0200 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2013-06-13 10:23:58 +0200

Ljiljan gravatar image

You can try to set up format number in blank document, save it as template, set up it as default template so every time you run Calc your number format will be loaded. And you can try to save it in Template folder (home/your name/templates) so you can create new file within Files with Right click -> New Document.

edit flag offensive delete link more

Comments

Thank you. That is the best alternate way. I wish someone from LO programmer/coder read this post and will add a new feature for future version of LO: save user-defined-number-format.

Paijo gravatar imagePaijo ( 2013-06-13 13:23:12 +0200 )edit

I understand you completely. I am using Impress and Draw more often, and I had to change border line and area fill each time I start doing something... so I created templates :) but Writer does not allow to change default border lines and area fill this way :(

Ljiljan gravatar imageLjiljan ( 2013-06-13 22:16:26 +0200 )edit

Your suggestion for workaround to this problem applicable for a new blank file. But to adjust already created files, it require more manual work.

BTW, I'm use Calc almost everyday, about 5 to 6 hours a day, and rarely use Impress , That's why most of my post is related to LO Calc.

Anyway, thank you for suggestion.

Paijo gravatar imagePaijo ( 2013-06-14 08:13:41 +0200 )edit
0

answered 2013-06-14 09:44:47 +0200

ROSt52 gravatar image

For existing file it is very easy if ALL cells should have your special format. In this case do

  • F11 / Default / right click Modify / tab Numbers and enter or select the format you want to have / OK

If the format should be only for certain areas of a sheet, than you have to do it area by area.

edit flag offensive delete link more

Comments

I end up modify the number format manually area-by-area.

Modifying style (F11), will replace current cell's background color, font, border, etc. While I just need to change only the number format.

Paijo gravatar imagePaijo ( 2013-06-14 11:09:54 +0200 )edit

Question Tools

Stats

Asked: 2013-06-12 11:22:51 +0200

Seen: 633 times

Last updated: Jun 14 '13