poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 54318] New: BuiltinFormats; Changes in the order of predefined formats
Date Mon, 17 Dec 2012 10:36:30 GMT
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: dev@poi.apache.org
          Reporter: mathias@sroke.de
    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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message