That's a short and good answer. Thank you!
Kind Regards Patrick Zimmermann -----Ursprüngliche Nachricht----- Von: Nick Burch [mailto:[email protected]] 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: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
