Bug 37684 - Unhandled Continue Record Error
Summary: Unhandled Continue Record Error
Status: RESOLVED FIXED
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
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-11-29 10:01 UTC by Savitha Papanna
Modified: 2008-01-19 06:42 UTC (History)
1 user (show)


Attachments
A sample file that causes said exception (32.00 KB, application/vnd.ms-excel)
2006-01-03 10:52 UTC, Youval 		Details
Unhandled Continue Record (81.00 KB, application/vnd.ms-excel)
2007-02-08 00:02 UTC, Ezz Lubbadeh 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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 
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:187)
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
(ExternalTableGener
ator.java:178)
at com.saternos.database.utilities.ExternalTableGenerator.main
(ExternalTableGenerato
r.java:81) 

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
TextObjectRecord.

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.

Thanks,

Youval
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.

Sorry.

Jason
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.

Yegor