Here are the issues I've encountered with CellFormat:
- for a format that has one section (e.g. "0.00"), negative numbers are
formatted without a minus ("-") sign
- for a format with three or four sections ("0.00;-0.00;-" or
"0.00;-0.00;-;@"), a negative number is formatted using the zero section and
vice versa
- for the "General" and "@" formats, decimal values are formatted with the
wrong number of decimal places
- TRUE and FALSE (for boolean values) are formatted in lower case
- date-time values are formatted incorrectly for a format with hours and
minutes but not seconds (e.g. "h:m")
(I've created a patch for the first four issues (bug 52708 in bugzilla), the
last issue is raised as bug 52438 and the fix will be in 3.8-beta6.)
Steve
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Reading-cell-values-that-have-a-custom-format-tp5486315p5497290.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
