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.
Could you please attach the sheet ? Cheers --Filippo
Please attach a sample spreadsheet. Without an example we can't do much to solve the problem. Yegor
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.
I added the document, which is error proned for this behaviour and should reproduce this bug. This occures definitily with POI 3.2.
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?
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
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
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.
Nightly download area poked, you should be fine to download from there now.