https://issues.apache.org/bugzilla/show_bug.cgi?id=45678
Summary: HSSFDataFormatter returns some incorrect formatted
strings
Product: POI
Version: 3.0-dev
Platform: PC
OS/Version: Windows Vista
Status: NEW
Severity: minor
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
When reading values from number cells, for some type of formatted numbers,
HSSFDataFormatter returns incorrect values:
1. Simple numbers: adds an underscore after the number in the formatted string,
using default number format, eg. a cell with the number 4455667788 is formatted
as a string like '4455667788_'.
2. Account numbers are formatted with different precision than in Excel, eg.
the number 0,896665 in excel, with 2 digits precision, is shown as 0,90.
HSSFDataFormatter returns 0,896665. The same number, as currency or number is
formatted as it appears in Excel (number, as reported above, adds an underscore
in the end of the string, it returns '0,90_'.
3. Fraction numbers always returns the string '1 ??/??'.
The XLS document was generated using Excel 2007 / portuguese, in Excel 97/2003
format.
Other kind of number formats work fine, like currency, date, hour, percentage,
scientific and phone numbers.
Brazilian zip codes (ddddd-ddd) are formatted as dddddddd- and taxpayer
registry numbers (ddddddddd-dd) as ddddddddddd-
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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]
