incubator-ooo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Zhang Lu <zhanglu....@gmail.com>
Subject Re: [DISCUSS][Calc] How to save locale code in number format importing form MS Excel.
Date Wed, 27 Jun 2012 01:59:24 GMT
Thanks Rob,
     OOo 3.3 also can't restore locale code, it's not a regression.
I think the root cause is there is no place to store locale code in
style.xml and content.xml, so if wonder if we should add an attribute
or element in ods to save this info?

On 6/27/12, Rob Weir <robweir@apache.org> wrote:
> 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
>

Mime
View raw message