Locale awareness in POI

["Zimmermann, Patrick" <pa...@haltec.de>]

Hello everyone,
 
I am using POI quite extensively at work. Generally it's working amazingly
smooth. Kudos to the developers!
 
I am currently looking into using POI with a non en_US locale. From what I
have found it looks, like in
most cases (e.g. number to text coercion) POI just assumes en_US and reacts
respectively. In some other
cases (e.g. some function implementations) it relies on the Java formatting
functionality, which in turn
relies on the system locales for formatting.
 
Can someone with a deeper knowledge of the codebase than me share a rough
overview of where POI is acting
locale aware and where it isn't?

Kind regards,
Patrick Zimmermann


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

AW: Locale awareness in POI

["Zimmermann, Patrick" <pa...@haltec.de>]

That's a short and good answer.
Thank you!


Kind Regards
Patrick Zimmermann

-----Ursprüngliche Nachricht-----
Von: Nick Burch [mailto:apache@gagravarr.org] 
Gesendet: Donnerstag, 25. September 2014 17:09
An: POI Users List
Betreff: Re: Locale awareness in POI

On Thu, 25 Sep 2014, Zimmermann, Patrick wrote:
> I am currently looking into using POI with a non en_US locale. From 
> what I have found it looks, like in most cases (e.g. number to text 
> coercion) POI just assumes en_US and reacts respectively.

The Excel file format is almost all in an en_US format. POI goes with what's
in the file

In some locales, Excel will display something different to what it writes in
the file (eg , not . for decimal points, dd/mm/yyyy dates despite a
mm/dd/yyyy date format being stored in the file etc). POI will only give you
the file version of these

It has been suggested that POI should optionally have a way to perform these
same translations, eg something you could give the in-file-format formatting
string and a locale, and get back the format that Excel silently uses
instead in that locale. However, it'd be quite a lot of work to put together
that list, and thus far no-one has felt sufficiently motivated to do the
investigations for it....

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: Locale awareness in POI

[Nick Burch <ap...@gagravarr.org>]

On Thu, 25 Sep 2014, Zimmermann, Patrick wrote:
> I am currently looking into using POI with a non en_US locale. From what 
> I have found it looks, like in most cases (e.g. number to text coercion) 
> POI just assumes en_US and reacts respectively.

The Excel file format is almost all in an en_US format. POI goes with 
what's in the file

In some locales, Excel will display something different to what it writes 
in the file (eg , not . for decimal points, dd/mm/yyyy dates despite a 
mm/dd/yyyy date format being stored in the file etc). POI will only give 
you the file version of these

It has been suggested that POI should optionally have a way to perform 
these same translations, eg something you could give the in-file-format 
formatting string and a locale, and get back the format that Excel 
silently uses instead in that locale. However, it'd be quite a lot of work 
to put together that list, and thus far no-one has felt sufficiently 
motivated to do the investigations for it....

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org