You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2014/11/19 11:33:33 UTC
[Bug 57236] New: DataFormatter, invalid conversion of General String
value
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
[Bug 57236] DataFormatter, invalid conversion of General String
value
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57236
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #2 from Dominik Stadler <do...@gmx.at> ---
Can you post your code? Preferrably as simple unit-test, so we can reproduce. I
tried quickly, but could not reproduce your problem with the sample file given.
--
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
[Bug 57236] DataFormatter, invalid conversion of General String
value
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57236
Kushal <Ku...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |Kushal.j1987@gmail.com
OS| |All
--
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
[Bug 57236] DataFormatter, invalid conversion of General String
value
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57236
--- Comment #1 from Kushal <Ku...@gmail.com> ---
Hi,
Any update on this issue?
--
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
[Bug 57236] DataFormatter, invalid conversion of General String
value
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57236
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--- Comment #3 from Dominik Stadler <do...@gmx.at> ---
I could reproduce it now, FYI, POI internally does the following, which fails
for such small numbers:
DecimalFormat format = new DecimalFormat("#.##########", new
DecimalFormatSymbols(Locale.getDefault()));
double d = 3.0E-104;
assertEquals("3.0E-104", format.format(d));
--
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