Bug 41725 - POI does not load excel file with more than 65 charts
Summary: POI does not load excel file with more than 65 charts
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.2-dev
Hardware: PC other
: P1 normal with 1 vote (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2007-02-28 04:59 UTC by Vishnudutt Gautam
Modified: 2009-08-18 06:07 UTC (History)
2 users (show)

Sheet with many charts making parser inaccesible (121.83 KB, application/octet-stream)
2009-06-08 06:02 UTC, Oliver Wolff

Note You need to log in before you can comment on or make changes to this bug.
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 ?


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.

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

    .id        = 3c

and the 'lastrecord' was 


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/

Comment 8 Oliver Wolff 2009-08-18 05:50:54 UTC
Sorry, but the URL
cannot be accessed via Firefox browser nor SVN-Explorer.

So I searched and found only

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.