Apache OpenOffice (AOO) Bugzilla – Issue 6692
User-defined number formats not saved properly
Last modified: 2003-09-08 16:55:29 UTC
I enter a user-defined number format (either using direct formatting with Format->Cells or using styles with Format->Style Catalog) with coding as follows: _(#,##0.00_);\(#,##0.00\);_(0.00_) Note that my purpose with the above code is to have negative numbers bracketed like this (123.45) and positive numbers and zero to leave space for the brackets. Thus all the decimals line up properly in a column with mixed positive and negative numbers. However, after saving a document with the above numeric format, closing the document, then reopening it, I find that the numeric code above has been replaced with: [>0]#,##0.00;[<0](#,##0.00);0.00 The problem of course being that now the positive and zero formats no longer leave space for the brackets in the negative format.
Hi Niklas, 1 4 u Frank
I have checked this out in 643 and it remains a problem. Something like this might not seem a big deal to some users, but for professional accountants (who tend to use spreadsheets a lot) this is a significant problem. The effect is this on a column of numbers: 1,234.56 (23.45) 7,890.12 In other words, the decimals don't line up when a negative number is formatted with brackets. This is not acceptable in materials that would be printed and given to clients. The formatting works until saving, closing, and then re-opening. It certainly is not very convenient to have to redo the formatting every time just before printing. I know you folks are very busy, but perhaps this could get notched up a little higher in the priority list?
Fixed in 644 and 1.0.2: The "_)" part is turned into a space character when saving (the same thing that happens for output). Internal ID is 103839.
set to verified
closed verified