Yes this is a bug and you should report it in bugzilla
<https://bz.apache.org/ooo/>
On 16/05/16 6:11 AM, Girvin R. Herr wrote:
Greetings,
AOO 4.1.2 on Slackware Linux 14.0 (K3.10.17).
I seem to be having a problem with a custom number format in Writer
table cells in a template. What I want is to display 2 digits to the
right of the decimal point if the value's third digit and beyond is
zero and 3 digits if the value's third digit is non zero. Examples:
Value Display Result
123.45 > 123.45
123.456 > 123.456
123.4562 > 123.456
I am using the following format code to do this:
[$$-409]#,##0.00#;[RED]-[$$-409]#,##0.00#
This format code works as long as I do not change the document's
template (update). When I open the document again, I get the message
that the template has changed and when I update the template, the
format in the document returns to:
[$$-409]#,##0.000;[RED]-[$$-409]#,##0.000
The root problem seems to be in the template save. When I change the
template format code to .00# and save it with the save icon, the next
time I open or use the template, it has reverted back to .000. I
re-read the help on custom format codes and it confirms that what I am
doing is supposed to work. In fact, it is one of the examples.
Is there something I need to do to make this format code sticky in the
template or is this a bug?
Thanks.
Girvin Herr
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
