I covered it with my confirmation of the Writer case, cross-referencing between Issue 126973 and Issue 126827.
I agree, the help is incorrect. In addition, while the Calc case works if the file is saved as Excel, there is no case that works for writer. Thanks for opening the issue, Girvin. - Dennis > -----Original Message----- > From: Girvin R. Herr [mailto:[email protected]] > Sent: Monday, May 16, 2016 14:29 > To: [email protected] > Subject: Re: Custom number format code problem > > 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 <[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] > > > > > > > --------------------------------------------------------------------- > 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]
