Bug 40164 - Read Excel file with Filter on first line generate an ArrayIndexOutOfBoundsException
Summary: Read Excel file with Filter on first line generate an ArrayIndexOutOfBoundsEx...
Status: RESOLVED WORKSFORME
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.5-FINAL
Hardware: Other Windows 2000
: P2 minor (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-08-02 14:15 UTC by Yves Galante
Modified: 2006-08-27 05:02 UTC (History)
0 users



Attachments
Excel file can't readed (13.50 KB, application/vnd.ms-excel)
2006-08-02 14:16 UTC, Yves Galante
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Yves Galante 2006-08-02 14:15:49 UTC
When POI read an Excel file with an automatic filter on top, an exception is 
leave.
If I remove the filter, POI can read Excel file.

See attached file

Trace :
java.lang.reflect.InvocationTargetException
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance
(NativeConstructorAccessorImpl.java:80)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance
(DelegatingConstructorAccessorImpl.java:44)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:315)
	at org.apache.poi.hssf.record.RecordFactory.createRecord
(RecordFactory.java:224)
	at org.apache.poi.hssf.record.RecordFactory.createRecords
(RecordFactory.java:160)
	at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>
(HSSFWorkbook.java:163)
	at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>
(HSSFWorkbook.java:130)
	at ch.generali.rea.reprise.cumul.excel.ExcelFile.load(ExcelFile.java:47)
	at ch.generali.rea.reprise.cumul.excel.UpdateExcel.updateExcel
(UpdateExcel.java:103)
	at ch.generali.rea.reprise.cumul.excel.UpdateExcel.main
(UpdateExcel.java:76)
Caused by: java.lang.ArrayIndexOutOfBoundsException
	at java.lang.System.arraycopy(Native Method)
	at org.apache.poi.hssf.record.UnknownRecord.<init>
(UnknownRecord.java:62)
	at org.apache.poi.hssf.record.SubRecord.createSubRecord
(SubRecord.java:57)
	at org.apache.poi.hssf.record.ObjRecord.fillFields(ObjRecord.java:99)
	at org.apache.poi.hssf.record.Record.fillFields(Record.java:90)
	at org.apache.poi.hssf.record.Record.<init>(Record.java:55)
	at org.apache.poi.hssf.record.ObjRecord.<init>(ObjRecord.java:61)
	... 11 more
org.apache.poi.hssf.record.RecordFormatException: Unable to construct record 
instance, the following exception occured: null
	at org.apache.poi.hssf.record.RecordFactory.createRecord
(RecordFactory.java:237)
	at org.apache.poi.hssf.record.RecordFactory.createRecords
(RecordFactory.java:160)
	at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>
(HSSFWorkbook.java:163)
	at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>
(HSSFWorkbook.java:130)
Comment 1 Yves Galante 2006-08-02 14:16:36 UTC
Created attachment 18670 [details]
Excel file can't readed
Comment 2 Jason Height 2006-08-27 12:02:53 UTC
Latest SVN Worksforme

JASON