On Tue, 19 May 2009, Chris Lott wrote:
The entry with numFmtId = 14 seems to be the style at index 1 that is referenced by the cell with the date value. Is this where the magic of formatting dates is buried? I sure don't see any local, custom format string in that styles table entry.
org.apache.poi.ss.usermodel.BuiltinFormats is probably the one you're looking for here
I tried calling DataFormatter#formatRawCellValue() passing it the double, short number format index, and null format string. Judging from the null-pointer exceptions I'm seeing, the formatRawCellValue() method needs a non-null format string.
Yup, I'd try it with the string you get back from BuiltinFormats for the ones where the Style Table doesn't have a custom one
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
