On Fri, 25 Apr 2014, Kilian Sprotte wrote:
Nick Burch <apache <at> gagravarr.org> writes:
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)

Switching the system locale to USA makes it work, like you suggested.

It would be good if some kind volunteers could help us crowd source the list of localised varients of the built-in formats which change! It'd need a bit of work, since there's lots of locales to check for, but it would help for your problem in future...

Nick

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

Reply via email to