https://issues.apache.org/bugzilla/show_bug.cgi?id=53076
Bug #: 53076
Summary: cell.getNumericCellValue() returns incorrect results
sometimes
Product: POI
Version: 3.6
Platform: PC
Status: NEW
Severity: major
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Classification: Unclassified
Created attachment 28604
--> https://issues.apache.org/bugzilla/attachment.cgi?id=28604
File demonstrating the bug
In an excel sheet processed through poi, getNumericCellValue() returned an
incorrect result for a decimal value. The file is attached. The issue happens
with the "Quantity" field of the first second row (-23,530.9150).
Value in .xls file: -23,530.9150
Formatting: Category - Number, Decimal Places - 4, Use 1000 separator - True
Value returned by getNumericCellValue: -23530.915000000045
--
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]
