Bug 37684 - Unhandled Continue Record Error
Summary: Unhandled Continue Record Error
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: Other Windows NT
: P2 blocker (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2005-11-29 10:01 UTC by Savitha Papanna
Modified: 2008-01-19 06:42 UTC (History)
1 user (show)

A sample file that causes said exception (32.00 KB, application/vnd.ms-excel)
2006-01-03 10:52 UTC, Youval
Unhandled Continue Record (81.00 KB, application/vnd.ms-excel)
2007-02-08 00:02 UTC, Ezz Lubbadeh

Note You need to log in before you can comment on or make changes to this bug.
Description Savitha Papanna 2005-11-29 10:01:15 UTC
The POI code i downloaded from this site to load data from a given excel file 
into an external DB works just fine for a few excels.. but for few others it 
throws an exception as below 

org.apache.poi.hssf.record.RecordFormatException: Unhandled Continue Record at 
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:183)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:152)
at com.saternos.database.utilities.ExternalTableGenerator.execute
at com.saternos.database.utilities.ExternalTableGenerator.main

Am not very sure why am getting this "Unhandled Continue Record" exception ..
Comment 1 Youval 2006-01-03 10:52:12 UTC
Created attachment 17310 [details]
A sample file that causes said exception

I've tried to create a minimal example that demonstrates this bug.  The
'comments.xls' contains 61 identical comments; iFf any of the comments is
removed, the file is loaded successfully.
Comment 2 Youval 2006-01-03 11:35:40 UTC
Hi there,

Apparently a ContinueRecord is not handled when the last record is a

I've created a patched version that simply ignores ContinueRecords in this case
(so that I can access the rest of the file), but this seems to be a little
dangerous ..

.. unless, with the new RecordInputStream (
http://issues.apache.org/bugzilla/show_bug.cgi?id=31906 ), the continue records
really should be ignored.

I'd appreciate any insights.


Comment 3 Jason Height 2006-01-23 07:09:01 UTC
Suggested change is not valid. Problem is more complex. The way that
ContinueRecord work with TextObjects and Graphics is wierd. This coulod take
some time to fully resolve.


Comment 4 Ezz Lubbadeh 2007-02-08 00:02:05 UTC
Created attachment 19544 [details]
Unhandled Continue Record
Comment 5 Ezz Lubbadeh 2007-02-08 00:06:19 UTC
Comment on attachment 19544 [details]
Unhandled Continue Record

Hello all,

I have encountered the same Unhandled Continue Record error, please view the
attached Excel file.

I still can't find the reason for the error.

if any one can help, it would be a great help.
Comment 6 Yegor Kozlov 2008-01-19 06:42:40 UTC
Works with POI 3.0.2 BETA2.