poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 57236] New: DataFormatter, invalid conversion of General String value
Date Wed, 19 Nov 2014 10:33:33 GMT
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: dev@poi.apache.org
          Reporter: Kushal.j1987@gmail.com

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message