https://issues.apache.org/bugzilla/show_bug.cgi?id=54686
Bug ID: 54686
Summary: Some Excel formats are displayed incorrect
Product: POI
Version: 3.8
Hardware: PC
Status: NEW
Severity: major
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Classification: Unclassified
Created attachment 30044
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30044&action=edit
DataFormatter changes
Some Excel formats are displayed incorrect in the application (fractional,
accounting and currency formats).
For example, this formats displays incorrect:
Category - Fraction:
1/4 (Up to one digit (1/4) cell type) --> 0/
21/25 (Up to two digits (21/25) cell type) --> 1/
1/2 (As halves (1/2) cell type) --> 0/2
2/4 (As quarters (2/4) cell type) --> 0/4
Category - Accounting:
0,001000000 (Decimal places - 9, Symbol - р.) --> 0,00
$ 1,234567890 (Decimal places - 9, Symbol - $English(Canada)) --> 1,23
Category - Currency:
0,001000000 (Decimal places - 9, Symbol - р.) --> 0,00
$ 1,234567890 (Decimal places - 9, Symbol - $English(Canada)) --> 1,23
--
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]
