To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=101642
User rainerbielefeld changed the following:
What |Old value |New value
================================================================================
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Keywords|needmoreinfo, oooqa |oooqa
--------------------------------------------------------------------------------
Summary|user-defined number format|particular user-defined nu
| lost on save |mber format lost on save
--------------------------------------------------------------------------------
Subcomponent|formatting |save-export
--------------------------------------------------------------------------------
------- Additional comments from rainerbielef...@openoffice.org Wed Oct 7
05:14:55 +0000 2009 -------
@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.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
