Dennis et al,
A specimen file is no problem. It is repeatable and can be verified in
any writer file. As a test, I just opened a new blank writer file,
inserted a 2x2 table, right-clicked in a table cell and brought up the
"Number Format" option. I then added the subject number format by
modifying the existing "Currency" | "-$1,234.00" (red) format by
appending the # to the $#,##0.00 fields, producing $#,##0.00#, and
clicking on "Add". This new format is then present in the "User
Defined" and "Currency" number Categories. However, saving this test
file and re-opening the test file shows that the $#,##0.00# fields are
changed to $#,##0.000.
I will look into reporting this in bugzilla. But if it is an ODF spec
problem, then it may not be fixable. The Help should be changed to
reflect the limitation, though.
Thanks.
Girvin Herr
On 05/16/2016 07:53 AM, Dennis E. Hamilton wrote:
Issue 126827 may be relevant to this also, having to do with the limitations of
how the ODF specification limits what can be recorded in the .odt file.
https://bz.apache.org/ooo/show_bug.cgi?id=126827
Assuming the user is operating with Writer and .odt, a specimen file would help
us see if that is the case.
- Dennis
-----Original Message-----
From: Martin Groenescheij [mailto:[email protected]]
Sent: Monday, May 16, 2016 01:00
To: [email protected]
Cc: [email protected]
Subject: Re: Custom number format code problem
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: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
