Mailing-List: contact ooo-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ooo-dev@incubator.apache.org
MIME-Version: 1.0
In-Reply-To: 
 <CACR2vQ6LXR3v0XFfTjPVZ6OAnWKuJTotqQttrJTt3-b6BH_1Vg@mail.gmail.com>
References: 
 <CACR2vQ6LXR3v0XFfTjPVZ6OAnWKuJTotqQttrJTt3-b6BH_1Vg@mail.gmail.com>
Date: Tue, 26 Jun 2012 14:08:01 -0400
Message-ID: 
 <CAP-ksoh_=yVj+KKqVFLgWP1ct6BUtKanEP4XQY8vus9SpSSJhg@mail.gmail.com>
Subject: Re: [DISCUSS][Calc] How to save locale code in number format
 importing form MS Excel.
From: Rob Weir <robweir@apache.org>
To: ooo-dev@incubator.apache.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

On Tue, Jun 26, 2012 at 2:27 AM, Zhang Lu <zhanglu.aoo@gmail.com> wrote:
> Hi All,
>
> =C2=A0 My name is Zhang Lu. I am a developer working in Symphony team. My
> special areas are number format, formula, and sc.
> =C2=A0 =C2=A0I found a issue in number format of sc, call for your help.
> =C2=A0 =C2=A0Step:
> =C2=A0 =C2=A01. Create a MS Excel in English locale, set one cell's numbe=
r
> format as "[$-407]d. mmm. yy;@" , which is a Germany date format.
> Saved as test.xls.(In attachment)
> =C2=A0 =C2=A02. Open test.xls via AOO, the cell's format code is still
> "[$-407]d. mmm. yy;@"
> =C2=A0 =C2=A03. 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.
> =C2=A0 =C2=A04. 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