Apache OpenOffice (AOO) Bugzilla – Issue 101642
particular user-defined number format lost on save
Last modified: 2013-01-29 21:48:32 UTC
User-defined number format lost on save/reopen. Input a currency format of "$ ???????;$ ???????-" is not preserved on a save / reopen of document. Same happens if this format is used in a text table with Writer. My objective in using this format is to have a fixed-width, right=justified number displayed. I use a monospaced font in the cell.
I checked with "Ooo 3.1.1 WIN XP DE-multilingual version German UI activated [OOO310m19 (Build 9420)]" and can confirm that the user formatting string will not be saved / reopened correctly, but I doubt that that is a correct OOo formatting string, and I see alternatiev formatting strings. @mjneedles: Still a problem for you? If yes, Please - specify your OS and Platform - contribute information concerning your OS and OOo localization - contribute -- a much more detailed step by step instruction how to reproduce the problem -- Information why you tried your formatting string and not something like [$$-407]" "0;[$$-407]" "0- or "$ "#;"$ "#- - Attach a sample document. If it worked for you with an older OOo version (what still is available for you), pls. create document with that old version.
Could you specify how to do what I want then, please? You say you "see alternative formatting strings."
Closing issue due to reporter's inactivity as WFM.
Please feel free to reopen this issue if you find out that the problem still exists in the latest release of OOo and if you can provide requested additional information.
Since you didn't answer my question either, I will reopen. I was attempting to produce a fixed width currency field where the currency symbol is at the left, the value right-justified with leading blanks and no decimal places. I could not find any "nice" way to do that.
Created attachment 65192 [details] Spreadsheet with user-defined currency format (lost)
Created attachment 65193 [details] Screenshot of what I expect from the format, which works until file is saved & reopened
@mjneedles: As I see in your attachments, you need a formatting that works like "leading zeros" (so that the "$" always will appear at the same place in the cell), but with blanks instead of zeros? I created a screenshot to show that. I can't find any hint (in HELP under "Number Format Codes") that your formatting string is an allowed one, although it works. On the other hand, in HELP under same heading / Examples I found "5.75 as 5 3/4 and 6.3 as 6 3/10 : # ???/???" what seems to show that the question mark can be a "leading blank", and that formatting string remains after save - close - open. So here we might have 2 Problems 1. The error handling for formatting strings is poor. If an invalid string has been inserted, there should be a message with a hint what's wrong 2. Currently, there seems to be no "legal" way to reach your goal "leading blanks" 3. A formatting string that works fine will be corrupted during "save as" (or "open"? I can't decide) I confirm the 3. problem from original report, for the present as a "save as" issue.
Created attachment 65194 [details] Showing reporter's ambition
@rainerbielefeld: You have stated my intent correctly, and your observations match mine exactly. Thank you.
Since this request/problem has to do with my request for the "accounting" number format in issue http://www.openoffice.org/issues/show_bug.cgi?id=110774 I will transfer my attention to the parent of that one, http://www.openoffice.org/issues/show_bug.cgi?id=15773 . The problem with this still exists, however, in that some user-defined formats are not saved properly.