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]
