Re: HSSFDataFormatter for Date values

2014-04-25 Thread Nick Burch
On Fri, 25 Apr 2014, Kilian Sprotte wrote: Nick Burch 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 local

Re: HSSFDataFormatter for Date values

2014-04-25 Thread Kilian Sprotte
Nick Burch 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

Re: HSSFDataFormatter for Date values

2014-04-17 Thread Nick Burch
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. How

HSSFDataFormatter for Date values

2014-04-17 Thread Kilian Sprotte
Hi, 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 s