On Tue, Jun 26, 2012 at 2:27 AM, Zhang Lu <zhanglu.aoo@gmail.com> wrote:
> Hi All,
>
> My name is Zhang Lu. I am a developer working in Symphony team. My
> special areas are number format, formula, and sc.
> I found a issue in number format of sc, call for your help.
> Step:
> 1. Create a MS Excel in English locale, set one cell's number
> format as "[$-407]d. mmm. yy;@" , which is a Germany date format.
> Saved as test.xls.(In attachment)
> 2. Open test.xls via AOO, the cell's format code is still
> "[$-407]d. mmm. yy;@"
> 3. Saved it as test.ods, and reopen it via AOO, you can find the
> format code change to "d. mmm. yy;@", the locale info([$-407]) lost.
> 4. Export to Excel, format code change to "d". "mmm". "yy;@"
>
> MS Excel support locale code in date and time format code, but AOO
> don't suport, and this info will be lost after saving to ods. In ods
> spec, there is no space to save this info(e.g. [$-407]).
I'm not very familiar with how Excel does it, but with ODF there is
stricter content/style separation. So the cell styles, including date
format, are stored in style definitions. It is possible to associate
a cell style with a specific locale. Look here for an example:
http://books.evc-cit.info/odbook/ch05.html#num-intl-section
But your example sounds simpler. It is odd that it does not work.
Did you try the same scenario in OOo 3.3? Maybe it is a regression?
-Rob
|