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: [email protected]
Reporter: [email protected]
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: [email protected]
For additional commands, e-mail: [email protected]
