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 <[email protected]> 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:[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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
