Issue 67605 - spreadsheet does not retain certain number formats
Summary: spreadsheet does not retain certain number formats
Status: CLOSED DUPLICATE of issue 54377
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0.3
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: ooo
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2006-07-20 11:21 UTC by terrynorth
Modified: 2013-08-07 15:14 UTC (History)
2 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description terrynorth 2006-07-20 11:21:01 UTC 
In two spreadsheets, I have several times amended a cell style from the number
format #,##0.000;[RED]-#,##0.000 to the format #,##0.00#;[RED]-#,##0.00#

The change is effective while the spreadsheet remains open but the format has
vanished completely when the spreadsheet is reopened.  Thus, it is impossible to
document this defect.  Similar problems have been reported in the forums and I
suspect other issues have been filed but my search does not reveal them.

There is a standard format 0.###;[BLACK]-0.### but, when I try to amend that to
show negative values in red, the selector switches to the standard format
0.000;[RED]-0.000 which does not serve the purpose, which is to show the third
decimal place only if it does not equal zero.
Comment 1 Rainer Bielefeld 2006-07-20 12:15:03 UTC 
@terrynorth:
Please contribute a simple step by step instruction how to reproduce the issue
It should look like
1. open new spreadsheet
2. set format for all fields to ....
3. Input "12,3" to A1
4. ...
Comment 2 frank 2006-08-31 13:49:15 UTC 
Hi Eike,

seems to be yours.

Frank
Comment 3 ooo 2006-08-31 20:01:24 UTC 
Dupe.

*** This issue has been marked as a duplicate of 54377 ***
Comment 4 ooo 2006-08-31 20:01:58 UTC 
Closing dup.