Issue 123149 - "Add leading digits" formatting feature supported, but lost after save as .ods
Summary: "Add leading digits" formatting feature supported, but lost after save as .ods
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: 3.4.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2013-08-31 11:20 UTC by Rainer Bielefeld
Modified: 2013-09-01 05:43 UTC (History)
3 users (show)

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

Sample Document (10.13 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2013-08-31 11:20 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Rainer Bielefeld 2013-08-31 11:20:10 UTC
Created attachment 81420 [details]
Sample Document

Steps how to reproduce Reproducible with  "AOO 4.1.0-Dev – English  UI / English  locale - [AOO410m1(Build:9750)  -  Rev. 1516435  2013-08-24]" on German WIN7 Home
Premium (64bit)", own separate user profile:

1. Open attached sample document
2. Select cells B2:B7
3.  Menu 'Format -> Cells... -> Numbers'
4. Copy / paste to Format Code: [BLUE]"¥"0#,##0.000;[RED]"¥"-0#,##0.000
5. <ok>
  > You will see results like "¥0300.000"
  > Some further investigation will show that to any number with less than 
    5 digits a leading "0" will be added for viewing, what is expected after
    examination of format code
6. Save as "mysample.ods"
7. Save as "mysample.xls" (MSO97)
8. close
9. Reopen "mysample.ods", "mysample.xls" and compare
   > .xls still shows leading zeroes                          :-)
   > .ods no longer shows leading zeroes                      :-(

Additional info:
a) This one is a spin off from "Bug 120942 - Cell Number format style is changed after saving to ods by AOO", because I did not understand conclusions there

b) Some investigations concerning format code:
b1) souce:   [BLUE]"¥"0#,##0.000;[RED]"¥"-0#,##0.000
b2) in .xls: [BLUE]\¥0#,##0.000;[RED]"¥-"0#,##0.000
b3) in .ods: [BLUE]"¥"#,#00.000;[RED]"¥-"#,#00.000

In xls there are some changes, but "add leading "0" feature still is in the code.

In ods "add leading "0" feature has been lost.

I wonder whether b3 is due to ODF limitatins or similar, but there should be a warning?

c) you also can add some other characters by format code, for example "!", but not simple characters like "a"

d) Not a new problem, already in OOo 1.1.5, where saveassample.sxc lost the 
   leading zeroes, while saveassample.xls keeps the feature
Comment 1 Rainer Bielefeld 2013-08-31 14:30:02 UTC
This one might be related to of even DUP of Bug 120942
Comment 2 Edwin Sharp 2013-09-01 05:43:20 UTC
As given in description.

Rev. 1516794 Win 7