https://issues.apache.org/bugzilla/show_bug.cgi?id=54318
Bug ID: 54318
Summary: BuiltinFormats; Changes in the order of predefined
formats
Product: POI
Version: 3.8
Hardware: PC
OS: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
Assignee: [email protected]
Reporter: [email protected]
Classification: Unclassified
I used POI (HSSF) for many years to export tables to excel. Since the update to
POI 3.8, I have a bug by formatting the cells of the table in Excel.
Environment:
Windows XP; Excel 2002, SP3;
The problem:
When I create a table, open it in Excel und click at the thousand separator,
the cell gets a ‘$’-Character in front of the number (formatted as currency).
Next, when I click on the button currency, Excel format the cell with the
thousands separator.
I get this problem with the SXSSF-libraries as well as with the HSSF-libraries.
Reason:
The order of the predefined formats in the class BuiltinFormats (package:
org.apache.poi.ss.usermodel) has changed.
3.8 (wrong)
putFormat(m, 0x29, "_(\"$\"* #,##0_);_(\"$\"* (#,##0);_(\"$\"* \"-\"_);_(@_)");
putFormat(m, 0x2a, "_(* #,##0_);_(* (#,##0);_(* \"-\"_);_(@_)");
putFormat(m, 0x2b, "_(\"$\"* #,##0.00_);_(\"$\"* (#,##0.00);_(\"$\"*
\"-\"??_);_(@_)");
putFormat(m, 0x2c, "_(* #,##0.00_);_(* (#,##0.00);_(* \"-\"??_);_(@_)");
3.7 (right)
putFormat(m, 0x29, "_(*#,##0_);_(*(#,##0);_(* \"-\"_);_(@_)");
putFormat(m, 0x2a, "_($*#,##0_);_($*(#,##0);_($* \"-\"_);_(@_)");
putFormat(m, 0x2b, "_(*#,##0.00_);_(*(#,##0.00);_(*\"-\"??_);_(@_)");
putFormat(m, 0x2c, "_($*#,##0.00_);_($*(#,##0.00);_($*\"-\"??_);_(@_)");
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
