Apache OpenOffice (AOO) Bugzilla – Issue 123149
"Add leading digits" formatting feature supported, but lost after save as .ods
Last modified: 2013-09-01 05:43:20 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
This one might be related to of even DUP of Bug 120942
As given in description. Rev. 1516794 Win 7