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]
