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 2008/07/08 21:17:32 UTC
DO NOT REPLY [Bug 45365] New: Converting sheet to csv gives
Malformed exponential pattern error
https://issues.apache.org/bugzilla/show_bug.cgi?id=45365
Summary: Converting sheet to csv gives Malformed exponential
pattern error
Product: POI
Version: unspecified
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: osssoftware@gmail.com
Created an attachment (id=22235)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22235)
Sheet causing Malformed exponential pattern error when converted to csv
Using v3.1 (20080629) and the code:
http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/eventusermodel/examples/XLS2CSVmra.java
I am converting many excel workbooks each with many (50+ sheets). For one
particular workbook I get an exception, java.lang.IllegalArgumentException with
message:
Malformed exponential pattern "0.00E+00". Looking at the workbook in question
there seems nothing obvious. Looking at XLS2CSVmra.java, it fails on the line
in the porocess() method:
factory.processWorkbookEvents(request, fs);
I went though all 84 sheets and narrowed it down to the problem sheet (see
attached poi.xls). I can't see what the problem is on this sheet, but it gives
the Malformed exponential pattern error every time
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 45365] Converting sheet to csv gives Malformed
exponential pattern error
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45365
--- Comment #5 from Tom Corcoran <os...@gmail.com> 2008-08-27 06:10:58 PST ---
Confirmation that updating XLS2CSVmra fixed this issue
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 45365] Converting sheet to csv gives Malformed
exponential pattern error
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45365
--- Comment #3 from Tom Corcoran <os...@gmail.com> 2008-08-05 16:37:57 PST ---
Created an attachment (id=22390)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22390)
Customised XLS2CSVmra used to create problem
Changes to downloaded XLS2CSVmra are all wrapped with // TC ADDED. Aside from a
package rename the only other changes are confined to some class variable
additions & processRecord which use BoundSheetRecord/BOFRecord to output the
sheetnames to the csv file.
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 45365] Converting sheet to csv gives Malformed
exponential pattern error
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45365
Nick Burch <ni...@torchbox.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|WONTFIX |FIXED
--- Comment #4 from Nick Burch <ni...@torchbox.com> 2008-08-06 10:52:59 PST ---
Your version of XLS2CSVmra is quite old, as it isn't using
formatListener.formatNumberDateCell to do the number conversion
Update to a newer version of XLS2CSVmra and you should be fine
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 45365] Converting sheet to csv gives Malformed
exponential pattern error
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45365
Tom Corcoran <os...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|FIXED |WONTFIX
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 45365] Converting sheet to csv gives Malformed
exponential pattern error
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45365
Nick Burch <ni...@torchbox.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #1 from Nick Burch <ni...@torchbox.com> 2008-07-10 11:41:16 PST ---
More crazy excel formatting rules, that java's decimal format doesn't like
Fixed in svn trunk
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 45365] Converting sheet to csv gives Malformed
exponential pattern error
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45365
--- Comment #2 from Tom Corcoran <os...@gmail.com> 2008-07-23 04:20:16 PST ---
Created an attachment (id=22303)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22303)
Spfreadsheet where defect reoccurs
tested with poi-3.2-alpha1-20080717.jar and defect reoccurred for this attached
spreadsheet
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org