Issue 121741 - Number formats with 0's followed by #'s after the decimal revert to all 0's after reload of document.
Summary: Number formats with 0's followed by #'s after the decimal revert to all 0's a...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 3.4.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: Anitha
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-02-08 19:35 UTC by Jason Olshefsky
Modified: 2013-09-12 08:38 UTC (History)
3 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 Jason Olshefsky 2013-02-08 19:35:10 UTC 
If a spreadsheet has a number format that contains both 0's and #'s after the decimal place (e.g. $0.00#### such that "1" displays as "$1.00" and "0.001" displays as "$0.001") then the trailing #'s are replaced by 0's when the document is closed and reopened. This appears to also apply to Styles.

1. Open a new Spreadsheet.
2. Enter 0.1234 in A1; enter 0.1 in A2.
3. Select cells column A.
4. Format > Cells...
5. Select Numbers tab.
6. Specify a format of "0.00####".
7. Click OK.
8. Confirm the cell A1 displays as "0.10" and A2 displays as "0.1234".
9. Save the spreadsheet as "bug.ods".
10. Close "bug.ods".
11. Reopen "bug.ods".
12. Notice that cell A1 displays as "0.100000" and A2 displays as "0.123400".
13. Select cell A1.
14. Format > Cells...
15. Select Numbers tab.
16. Notice that the format is now "0.000000".
Comment 1 Jason Olshefsky 2013-02-16 13:55:25 UTC 
One workaround is to format using the TEXT() function which saves correctly. For instance, TEXT(A1;"$0.00####") will always format as expected.
Comment 2 Edwin Sharp 2013-09-12 08:38:03 UTC 
As given in description (note error mixing between A1 and A2).

Rev. 1520602 Win 7