Issue 101642 - particular user-defined number format lost on save
Summary: particular user-defined number format lost on save
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 3.0.1
Hardware: Unknown All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2009-05-07 14:23 UTC by mjneedles
Modified: 2013-01-29 21:48 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Spreadsheet with user-defined currency format (lost) (10.19 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-10-07 03:18 UTC, mjneedles
no flags Details
Screenshot of what I expect from the format, which works until file is saved & reopened (160.78 KB, image/png)
2009-10-07 03:19 UTC, mjneedles
no flags Details
Showing reporter's ambition (81.80 KB, application/pdf)
2009-10-07 06:28 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description mjneedles 2009-05-07 14:23:58 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.
Comment 1 Rainer Bielefeld 2009-09-21 14:58:26 UTC
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.


Still a problem for you? If yes, 
- 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 
  -- 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. 
Comment 2 mjneedles 2009-09-22 09:40:19 UTC
Could you specify how to do what I want then, please? You say you "see
alternative formatting strings."
Comment 3 Rainer Bielefeld 2009-09-30 05:52:10 UTC
Closing issue due to reporter's inactivity as WFM.
Comment 4 Rainer Bielefeld 2009-09-30 05:52:29 UTC
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
Comment 5 mjneedles 2009-10-07 02:52:20 UTC
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. 
Comment 6 mjneedles 2009-10-07 03:18:27 UTC
Created attachment 65192 [details]
Spreadsheet with user-defined currency format (lost)
Comment 7 mjneedles 2009-10-07 03:19:20 UTC
Created attachment 65193 [details]
Screenshot of what I expect from the format, which works until file is saved & reopened
Comment 8 Rainer Bielefeld 2009-10-07 06:14:55 UTC
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.
Comment 9 Rainer Bielefeld 2009-10-07 06:28:51 UTC
Created attachment 65194 [details]
Showing reporter's ambition
Comment 10 mjneedles 2009-10-07 17:40:14 UTC
@rainerbielefeld: You have stated my intent correctly, and your observations
match mine exactly.  Thank you.
Comment 11 mjneedles 2010-04-19 19:51:33 UTC
Since this request/problem has to do with my request for the "accounting" number
format in issue I will
transfer my attention to the parent of that one, .

The problem with this still exists, however, in that some user-defined formats
are not saved properly.