https://issues.apache.org/ooo/show_bug.cgi?id=123149
Bug ID: 123149
Issue Type: DEFECT
Summary: "Add leading digits" formatting feature supported, but
lost after save as .ods
Product: Calc
Version: 3.4.0
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: open-import
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Created attachment 81420
--> https://issues.apache.org/ooo/attachment.cgi?id=81420&action=edit
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
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
