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@...
        ReportedBy: osssoftware@...


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

https://issues.apache.org/bugzilla/show_bug.cgi?id=45365


Nick Burch <nick@...> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED




--- Comment #1 from Nick Burch <nick@...>  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@...
For additional commands, e-mail: dev-help@...

https://issues.apache.org/bugzilla/show_bug.cgi?id=45365





--- Comment #2 from Tom Corcoran <osssoftware@...>  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@...
For additional commands, e-mail: dev-help@...

https://issues.apache.org/bugzilla/show_bug.cgi?id=45365


Tom Corcoran <osssoftware@...> 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@...
For additional commands, e-mail: dev-help@...

https://issues.apache.org/bugzilla/show_bug.cgi?id=45365





--- Comment #3 from Tom Corcoran <osssoftware@...>  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@...
For additional commands, e-mail: dev-help@...

https://issues.apache.org/bugzilla/show_bug.cgi?id=45365


Nick Burch <nick@...> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|WONTFIX                     |FIXED




--- Comment #4 from Nick Burch <nick@...>  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@...
For additional commands, e-mail: dev-help@...

https://issues.apache.org/bugzilla/show_bug.cgi?id=45365





--- Comment #5 from Tom Corcoran <osssoftware@...>  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@...
For additional commands, e-mail: dev-help@...