On Fri, 19 Feb 2010, David Law wrote:
It would seem there is a problem in HSSFCellStyle.getDataFormatString().
Delving even deeper, HSSFCellStyle relies on a static list from
BuiltinFormats.
The concept of fixed standard Builtin formats used in poi does not seem to
hold water.
It's not our concept. It's a core excel concept. The list of formats from
BuiltinFormats comes straight out of the microsoft documentation. If you
grab the latest microsoft docs (june 2008), and turn to page 372 you'll
see that same list
I have created a test Excel under german Windows & Excel & documented
which format strings were used & what results are displayed in poi & Excel.
It's possible that newer versions of excel translate some of the built in
formats into local equivalents. However, what's generally supposed to
happen is that if you want the german format, you create a custom format
of that kind.
POI's only a file format library, not a replacement for excel. We give you
what's in the file.
If you fancy producing a patch which allows per-locale versions of the
built in formats, I think we'd be happy to accept it, but it'll be a lot
of work for you switching your machine between each one to discover the
magic that excel does and which isn't in the documentation...
(By the way, perhaps not surprisingly, Open Office exhibits the same
behaviour)
They almost certainly read the same public documentation that we did!
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
