You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2012/12/17 11:36:30 UTC

[Bug 54318] New: BuiltinFormats; Changes in the order of predefined formats

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

[Bug 54318] BuiltinFormats; Changes in the order of predefined formats

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54318

Bernhard Seebass <se...@gmx.ch> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |eric@peters.org

--- Comment #2 from Bernhard Seebass <se...@gmx.ch> ---
*** Bug 55730 has been marked as a duplicate of this bug. ***

-- 
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

[Bug 54318] BuiltinFormats; Changes in the order of predefined formats

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54318

Bernhard Seebass <se...@gmx.ch> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |seebass@gmx.ch

-- 
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

[Bug 54318] BuiltinFormats; Changes in the order of predefined formats

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54318

--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
http://support.microsoft.com/kb/147942 claims to be the canonical, corrected
list of the built in formats. 

It does look like BuiltinFormats doesn't match the corrected list, so probably
it needs changing. (My hunch is someone updated based on the list somewhere
that featured the mistake mentioned in the kb article)

-- 
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

[Bug 54318] BuiltinFormats; Changes in the order of predefined formats

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54318

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |dominik.stadler@gmx.at

-- 
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