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 2017/04/27 06:58:40 UTC

[Bug 61049] New: Incorrect ordering in formats of BuiltinFormats.java

https://bz.apache.org/bugzilla/show_bug.cgi?id=61049

            Bug ID: 61049
           Summary: Incorrect ordering in formats of BuiltinFormats.java
           Product: POI
           Version: 3.16-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: SS Common
          Assignee: dev@poi.apache.org
          Reporter: intel2@naver.com
  Target Milestone: ---

Created attachment 34960
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=34960&action=edit
result in excel and MS Internal Format List

Hi.

I used poi library(ver 3.12) to create xls file. And I've found a bug.

I noticed that when a xls file is created using POI, the default style for the
button "Comma Style" results in the format which includes the currency
symbol("$").

Checking the source(in file BuiltinFormats.java), where internal formats are
defined, I found the following,

putFormat(m, 0x29, "_(\"$\"* #,##0_);_(\"$\"* (#,##0);_(\"$\"* \"-\"_);_(@_)");
putFormat(m, 0x2a, "_(* #,##0_);_(* (#,##0);_(* \"-\"_);_(@_)");

But in excel's internal format list, two entries are

0x29      _(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)
0x2a      _($* #,##0_);_($*(#,##0);_($* "-"_);_(@_)

Even in comments of BuiltinFormats.java, there are

 *       0x29, "_(* #,##0_);_(* (#,##0);_(* \"-\"_);_(@_)"<br/>
 *       0x2a, "_($* #,##0_);_($* (#,##0);_($* \"-\"_);_(@_)"<br/>

So you have to fix this part.


* ps : It is same in 3.16.

-- 
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 61049] Incorrect ordering in formats of BuiltinFormats.java

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

Tim Allison <ta...@mitre.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

--- Comment #1 from Tim Allison <ta...@mitre.org> ---
Thank you for raising this.  Will fix shortly.

-- 
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 61049] Incorrect ordering in formats of BuiltinFormats.java

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

Tim Allison <ta...@mitre.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |FIXED
             Status|NEW                         |RESOLVED

--- Comment #2 from Tim Allison <ta...@mitre.org> ---
r1792918


Thank you, again, for raising this.  Let us know if you find anything else.

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