Bug 41725

Summary:	POI does not load excel file with more than 65 charts
Product:	POI	Reporter:	Vishnudutt Gautam <vishnudutt_gautam>
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED LATER
Severity:	normal	CC:	filippo.balicchia, oliver.wolff
Priority:	P1
Version:	3.2-dev
Target Milestone:	---
Hardware:	PC
OS:	other
Attachments:	Sheet with many charts making parser inaccesible

Description Vishnudutt Gautam 2007-02-28 04:59:38 UTC

I have an excel sheet with 280 pie charts. when i try to read this file using 
POI 3.0, it doesnt load the file, instead throws an exception saying 
RecordFormatExcetption : Unhandled Record error. When i decreased the number of 
charts to 65 it starts working, when i make it 66 it again gives the same 
error. Iam using simple pie charts.

Comment 1 filippo balicchia 2008-06-04 10:12:39 UTC

Could you please attach the sheet ?

Cheers

--Filippo

Comment 2 Yegor Kozlov 2009-04-04 06:22:55 UTC

Please attach a sample spreadsheet. Without an example we can't do much to solve the problem.

Yegor

Comment 3 Oliver Wolff 2009-06-08 06:02:20 UTC

Created attachment 23774 [details]
Sheet with many charts making parser inaccesible

Row Value: 21 - Column Value: K
Sheet Nr.: 6
Count of cells: 12
Direction from top to down with Step: 17

That means reading first K21 at sheet 6, then k38 at sheet 6 etc. to k208. But it simply crashed at first cell k21 catching a RecordFormatException.

Comment 4 Oliver Wolff 2009-07-16 07:16:46 UTC

I added the document, which is error proned for this behaviour and should reproduce this bug. This occures definitily with POI 3.2.

Comment 5 Nick Burch 2009-07-27 08:01:35 UTC

Any chance you could upload the bit of the stacktrace around the RecordFormatException, so we can see which record it is that's failing to initialise on the file?

Comment 6 Thomas Wiesner 2009-08-13 05:05:38 UTC

The stack trace is

org.apache.poi.hssf.record.RecordFormatException: Unhandled Continue Record
	at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:364)
	at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:271)
	at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:196)
	at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:178)

I've debuuged the source until the exception will be thrown.

The 'record' is

[CONTINUE RECORD]
    .id        = 3c
[/CONTINUE RECORD]

and the 'lastrecord' was 

[EOF]
[/EOF]

Hope, this information helps

Comment 7 Yegor Kozlov 2009-08-14 12:50:01 UTC

Try the latest build. The attached file can be read by the latest build of trunk without any problems.

Daily builds can be downloaded from http://encore.torchbox.com/poi-svn-build/

Yegor

Comment 8 Oliver Wolff 2009-08-18 05:50:54 UTC

Sorry, but the URL
http://encore.torchbox.com/poi-svn-build/
cannot be accessed via Firefox browser nor SVN-Explorer.

So I searched and found only
http://apache.easy-webs.de/poi/dev/bin/poi-bin-3.5-beta6-20090622.zip

Do you mean this or do you mean the latest build from the minor release 3.2? I cannot access.

Comment 9 Nick Burch 2009-08-18 06:07:03 UTC

Nightly download area poked, you should be fine to download from there now.