template not copying user-defined format, normal behavior? [closed]

asked 2015-04-06 20:26:30 +0200

LibreGuy gravatar image


Just out of curiousity. When within a template I create a user-defined number in "format cells" and assign this to a (new) style, the style gets copied into documents based on that template, but the user-defined number is not, making the copied style kinda worthless. Is that normal behavior, or am I perhaps doing something wrong?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-19 22:13:57.941804


Please what is the user-defined number doesn't working?

m.a.riosv gravatar imagem.a.riosv ( 2015-04-06 23:47:28 +0200 )edit

What do you mean? I don't quite understand your question. In the template create a user-defined number under format cells->numbers. Create a new style and apply your new user-defined number to that style. Save the template. Open a document based on the template and choose to update styles. The style will now appear in the document, but on the "numbers" tab "standard" will be selected instead of the user-defined number you created in the template.

LibreGuy gravatar imageLibreGuy ( 2015-04-07 02:22:55 +0200 )edit

What is the number format that you have defined and not saved?

m.a.riosv gravatar imagem.a.riosv ( 2015-04-07 02:44:46 +0200 )edit

The number IS saved within the template, but does not copy to documents based on that template. A user-defined number could be for example: #.##0;"WRONG" This only shows positive numbers and shows the text "WRONG" when the number is 0 or negative.

LibreGuy gravatar imageLibreGuy ( 2015-04-07 09:33:47 +0200 )edit