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