I wish I knew the answer. When I click on the Apache Open Office task bar it leaps into action and then instantly closes so that I have to click again. Always.
________________________________________ From: Girvin R. Herr <[email protected]> Sent: Sunday, May 15, 2016 4:11 PM To: OpenOffice Users Subject: Custom number format code problem 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]
