https://issues.apache.org/bugzilla/show_bug.cgi?id=57236
Bug ID: 57236
Summary: DataFormatter, invalid conversion of General String
value
Product: POI
Version: 3.10-FINAL
Hardware: PC
Status: NEW
Severity: major
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Created attachment 32214
--> https://issues.apache.org/bugzilla/attachment.cgi?id=32214&action=edit
Input FIles
We are facing a issue when we are trying to convert an excel file with below
values to csv file.
Cell value : 3E-104
5E-104
5E-106
All the above values are getting converted to 0 , in a csv . Cell format in MS
Excel is 'General'
Java code used for the conversion
DataFormatter formatter = new DataFormatter(true);
String fmtCellValue = formatter.formatCellValue(cell);
I am attaching the sample of excel file.
Versions tested : POI - 3.9, 3.10-Final, 3.10.1, 3.11-beta3
--
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]
