Converting to csv: Malformed exponential pattern "0.00E+00"

[tom corcoran-5]

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);
What's the best way to try and toubleshoot this more?

Tom.

[tom corcoran-5]

I went though all 84 sheets and narrowed it down to the problem sheet. I
can't see what the problem is on this sheet, but it gives the Malformed
exponential pattern error every time. Here it is for download
http://www.filedropper.com/poi

Thanks a lot,

Tom.

On Tue, Jul 1, 2008 at 4:37 PM, tom corcoran <osssoftware@...> wrote:

> 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);
> What's the best way to try and toubleshoot this more?
>
> Tom.
>

[Nick Burch]

On Tue, 1 Jul 2008, tom corcoran wrote:
> I went though all 84 sheets and narrowed it down to the problem sheet. I
> can't see what the problem is on this sheet, but it gives the Malformed
> exponential pattern error every time. Here it is for download
> http://www.filedropper.com/poi

Any chance you could create a new bug on bugzilla, and upload the file
there? filedropper doesn't seem to want to give me the file :(

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@...
For additional commands, e-mail: user-help@...

[tom corcoran-5]

Thanks Nick. Done. See Bug 45365.

Cheers, Tom.

ps. Note that bugzilla needed to be updated to show version 3.1 as currently
the highest v it shows is 3.0 dev.

On Tue, Jul 8, 2008 at 6:02 PM, Nick Burch <nick@...> wrote:

> On Tue, 1 Jul 2008, tom corcoran wrote:
>
>> I went though all 84 sheets and narrowed it down to the problem sheet. I
>> can't see what the problem is on this sheet, but it gives the Malformed
>> exponential pattern error every time. Here it is for download
>> http://www.filedropper.com/poi
>>
>
> Any chance you could create a new bug on bugzilla, and upload the file
> there? filedropper doesn't seem to want to give me the file :(
>
> Nick
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@...
> For additional commands, e-mail: user-help@...
>
>

[tom corcoran-5]

Hi Nick,

I just checked the status and saw that this was fixed, fantastic. Do you
have an idea of expected release dates? I did spend about an hour trying to
build it before but did not find it easy to do I'm afraid.

Thanks, Tom.

On Tue, Jul 8, 2008 at 8:19 PM, tom corcoran <osssoftware@...> wrote:

> Thanks Nick. Done. See Bug 45365.
>
> Cheers, Tom.
>
> ps. Note that bugzilla needed to be updated to show version 3.1 as
> currently the highest v it shows is 3.0 dev.
>
> On Tue, Jul 8, 2008 at 6:02 PM, Nick Burch <nick@...> wrote:
>
>> On Tue, 1 Jul 2008, tom corcoran wrote:
>>
>>> I went though all 84 sheets and narrowed it down to the problem sheet. I
>>> can't see what the problem is on this sheet, but it gives the Malformed
>>> exponential pattern error every time. Here it is for download
>>> http://www.filedropper.com/poi
>>>
>>
>> Any chance you could create a new bug on bugzilla, and upload the file
>> there? filedropper doesn't seem to want to give me the file :(
>>
>> Nick
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@...
>> For additional commands, e-mail: user-help@...
>>
>>
>

[Nick Burch]

On Thu, 17 Jul 2008, tom corcoran wrote:
> I just checked the status and saw that this was fixed, fantastic. Do you
> have an idea of expected release dates? I did spend about an hour trying to
> build it before but did not find it easy to do I'm afraid.

If you have ant, it should do all the work for you. Otherwise, nightlies
are available from http://encore.torchbox.com/poi-svn-build/

I expect there'll be 3.1.1 fairly soon, but I'm not the 3.1 release
manager so I can't say any more!

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@...
For additional commands, e-mail: user-help@...

[tom corcoran-5]

Nightly jars!! The secret is out! Thanks a lot. Tom.

On Thu, Jul 17, 2008 at 4:32 PM, Nick Burch <nick@...> wrote:

> On Thu, 17 Jul 2008, tom corcoran wrote:
>
>> I just checked the status and saw that this was fixed, fantastic. Do you
>> have an idea of expected release dates? I did spend about an hour trying
>> to
>> build it before but did not find it easy to do I'm afraid.
>>
>
> If you have ant, it should do all the work for you. Otherwise, nightlies
> are available from http://encore.torchbox.com/poi-svn-build/
>
> I expect there'll be 3.1.1 fairly soon, but I'm not the 3.1 release manager
> so I can't say any more!
>
>
> Nick
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@...
> For additional commands, e-mail: user-help@...
>
>

[tom corcoran-5]

Nick,

With poi-3.2-alpha1-20080717.jar I rested this and I got "Malformed
exponential pattern "0.00E+00" again. I have added another spreadsheet to
#45365 which duplicates the error again.

Thanks, Tom.

On Tue, Jul 8, 2008 at 8:19 PM, tom corcoran <osssoftware@...> wrote:

> Thanks Nick. Done. See Bug 45365.
>
> Cheers, Tom.
>
> ps. Note that bugzilla needed to be updated to show version 3.1 as
> currently the highest v it shows is 3.0 dev.
>
> On Tue, Jul 8, 2008 at 6:02 PM, Nick Burch <nick@...> wrote:
>
>> On Tue, 1 Jul 2008, tom corcoran wrote:
>>
>>> I went though all 84 sheets and narrowed it down to the problem sheet. I
>>> can't see what the problem is on this sheet, but it gives the Malformed
>>> exponential pattern error every time. Here it is for download
>>> http://www.filedropper.com/poi
>>>
>>
>> Any chance you could create a new bug on bugzilla, and upload the file
>> there? filedropper doesn't seem to want to give me the file :(
>>
>> Nick
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@...
>> For additional commands, e-mail: user-help@...
>>
>>
>

[tom corcoran-5]

Hi Nick,

Did you manage to have a look at this again....
https://issues.apache.org/bugzilla/show_bug.cgi?id=45365

Just wanted to make sure you were aware of it. I'm sure there are more
pressing issues.

Thanks a lot,

Tom.

On Wed, Jul 23, 2008 at 4:22 AM, tom corcoran <osssoftware@...> wrote:

> Nick,
>
> With poi-3.2-alpha1-20080717.jar I rested this and I got "Malformed
> exponential pattern "0.00E+00" again. I have added another spreadsheet to
> #45365 which duplicates the error again.
>
> Thanks, Tom.
>
>
> On Tue, Jul 8, 2008 at 8:19 PM, tom corcoran <osssoftware@...>wrote:
>
>> Thanks Nick. Done. See Bug 45365.
>>
>> Cheers, Tom.
>>
>> ps. Note that bugzilla needed to be updated to show version 3.1 as
>> currently the highest v it shows is 3.0 dev.
>>
>> On Tue, Jul 8, 2008 at 6:02 PM, Nick Burch <nick@...> wrote:
>>
>>> On Tue, 1 Jul 2008, tom corcoran wrote:
>>>
>>>> I went though all 84 sheets and narrowed it down to the problem sheet. I
>>>> can't see what the problem is on this sheet, but it gives the Malformed
>>>> exponential pattern error every time. Here it is for download
>>>> http://www.filedropper.com/poi
>>>>
>>>
>>> Any chance you could create a new bug on bugzilla, and upload the file
>>> there? filedropper doesn't seem to want to give me the file :(
>>>
>>> Nick
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-unsubscribe@...
>>> For additional commands, e-mail: user-help@...
>>>
>>>
>>
>

[Nick Burch]

On Mon, 4 Aug 2008, tom corcoran wrote:
> Did you manage to have a look at this again....
> https://issues.apache.org/bugzilla/show_bug.cgi?id=45365

I'm pretty sure it's fixed in trunk. Do you want to try again on a newer
build?

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@...
For additional commands, e-mail: user-help@...

[tom corcoran-5]

Hi Nick,

I ran it again last night with poi-3.2-alpha1-20080804.jar and after 5 hours
it crashed on the same file as before :-(

Tom.

On Mon, Aug 4, 2008 at 12:53 PM, Nick Burch <nick@...> wrote:

> On Mon, 4 Aug 2008, tom corcoran wrote:
>
>> Did you manage to have a look at this again....
>> https://issues.apache.org/bugzilla/show_bug.cgi?id=45365
>>
>
> I'm pretty sure it's fixed in trunk. Do you want to try again on a newer
> build?
>
>
> Nick
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@...
> For additional commands, e-mail: user-help@...
>
>

[Nick Burch]

On Tue, 5 Aug 2008, tom corcoran wrote:
> I ran it again last night with poi-3.2-alpha1-20080804.jar and after 5
> hours it crashed on the same file as before :-(

Try as I might, I can't reproduce the error with either of the two files
you've uploaded to bug #45365

My attempts can be seen in
src/testcases/org/apache/poi/hssf/eventusermodel/TestFormatTrackingHSSFListener.java
- look in the testTurnToString() method especially

I can also run org.apache.poi.hssf.eventusermodel.examples.XLS2CSVmra
against both your files without an exception

Any chance you could write a small unit test / program that runs against
one of your two files from the bug, and triggers the exception? That way
I'll have something to debug against :)

Nic

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@...
For additional commands, e-mail: user-help@...

[tom corcoran-5]

Thanks for the update Nic. I will try if I can uncouple a SSCCE together. I
have uploaded my customised version of XLS2CSVmra to defect #45365 which I
hope is not the issue....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.

Tom.
On Tue, Aug 5, 2008 at 3:33 PM, Nick Burch <nick@...> wrote:

> On Tue, 5 Aug 2008, tom corcoran wrote:
>
>> I ran it again last night with poi-3.2-alpha1-20080804.jar and after 5
>> hours it crashed on the same file as before :-(
>>
>
> Try as I might, I can't reproduce the error with either of the two files
> you've uploaded to bug #45365
>
> My attempts can be seen in
> src/testcases/org/apache/poi/hssf/eventusermodel/TestFormatTrackingHSSFListener.java
> - look in the testTurnToString() method especially
>
> I can also run org.apache.poi.hssf.eventusermodel.examples.XLS2CSVmra
> against both your files without an exception
>
> Any chance you could write a small unit test / program that runs against
> one of your two files from the bug, and triggers the exception? That way
> I'll have something to debug against :)
>
> Nic
>

[tom corcoran-5]

Just confirming that updating to the latest XLS2CSVmra solved this issue.
Thanks, Tom.

On Tue, Aug 5, 2008 at 4:41 PM, tom corcoran <osssoftware@...> wrote:

>  Thanks for the update Nic. I will try if I can uncouple a SSCCE together.
> I have uploaded my customised version of XLS2CSVmra to defect #45365 which I
> hope is not the issue....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.
>
> Tom.
>  On Tue, Aug 5, 2008 at 3:33 PM, Nick Burch <nick@...> wrote:
>
>> On Tue, 5 Aug 2008, tom corcoran wrote:
>>
>>> I ran it again last night with poi-3.2-alpha1-20080804.jar and after 5
>>> hours it crashed on the same file as before :-(
>>>
>>
>> Try as I might, I can't reproduce the error with either of the two files
>> you've uploaded to bug #45365
>>
>> My attempts can be seen in
>> src/testcases/org/apache/poi/hssf/eventusermodel/TestFormatTrackingHSSFListener.java
>> - look in the testTurnToString() method especially
>>
>> I can also run org.apache.poi.hssf.eventusermodel.examples.XLS2CSVmra
>> against both your files without an exception
>>
>> Any chance you could write a small unit test / program that runs against
>> one of your two files from the bug, and triggers the exception? That way
>> I'll have something to debug against :)
>>
>> Nic
>>
>