Martin,
I never tested it with Calc. Thanks.
You should add this to the bugzilla issue 126973 I created. If you
don't want to, let me know and I will append this to my comments. It
would be better coming from you, though.
Girvin
On 05/16/2016 01:47 PM, Martin Groenescheij wrote:
I hVe test this also with Calc and it has the same problem.
Sent from my iPhone
On 17 May 2016, at 5:53 AM, Girvin R. Herr <gherr...@sbcglobal.net> wrote:
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:mar...@groenescheij.com]
Sent: Monday, May 16, 2016 01:00
To: users@openoffice.apache.org
Cc: mar...@groenescheij.com
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: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
