On Thu, 17 Apr 2014, Kilian Sprotte wrote:
I am using HSSFDataFormatter to read date values as a string.
My aim is to read a string that is as close to the Excel representation
as possible.
This basically works - I can see that HSSFDataFormatter reacts differently
to different date formats.
However, when I would expect to receive a string like
"3. Januar 2014", instead I get "3/ Januar 2014".
If you, on a windows machine, switch the locale to USA and then open the
file in Excel, does it look the same in Excel then as it does in POI now?
(Excel does some transparent rewriting of format strings in some locales,
writing the US version to the file but displaying a different one when
opened. Apache POI doesn't (yet) have the list of localised versions)
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org
