You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2003/10/29 07:48:47 UTC
DO NOT REPLY [Bug 24207] New: -
Call HSSFName.getReference() throwing java.lang.IndexOutOfBoundsException
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=24207>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND
INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=24207
Call HSSFName.getReference() throwing java.lang.IndexOutOfBoundsException
Summary: Call HSSFName.getReference() throwing
java.lang.IndexOutOfBoundsException
Product: POI
Version: unspecified
Platform: PC
OS/Version: Other
Status: NEW
Severity: Critical
Priority: Other
Component: HSSF
AssignedTo: poi-dev@jakarta.apache.org
ReportedBy: w_ambrose@hotmail.com
I am using the poi-1.8.0-dev package.
The following is a part of my program.
POIFSFileSystem fs =
new POIFSFileSystem(new FileInputStream
("C:\\Projects\\KPM\\POI Test\\xls\\SimpleForm.xls"));
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheet("DataCollectionForm");
HSSFRow row = null;
HSSFCell cell = null;
HSSFName name = null;
CellReference ref = null;
int index = 0;
/* Read a locked cell */
index = wb.getNameIndex("Form_4.1_01");
System.out.println("index = " + index);
System.out.println("count = " + wb.getNumberOfNames());
name = wb.getNameAt(index);
System.out.println("name = " + name.toString());
System.out.println("name's name = " + name.getNameName
());
System.out.println("name's sheet = " + name.getSheetName
());
System.out.println("ref = " + name.getReference());
ref = new CellReference(name.getReference().substring
(name.getReference().indexOf("!")+1));
row = sheet.getRow(ref.getRow());
cell = row.getCell((short)ref.getCol());
System.out.println("The value of Form_4.1_01 is " +
cell.getStringCellValue());
When calling name.getReference() function, the IndexOutOfBoundsException was
thrown as the following:
java.lang.IndexOutOfBoundsException: Index: 8, Size: 6
at java.util.ArrayList.RangeCheck(Unknown Source)
at java.util.ArrayList.get(Unknown Source)
at org.apache.poi.hssf.model.Workbook.getSheetName(Workbook.java:460)
at org.apache.poi.hssf.model.Workbook.findSheetNameFromExternSheet
(Workbook.java:1693)
at org.apache.poi.hssf.model.Workbook.getSheetReferences
(Workbook.java:1678)
at org.apache.poi.hssf.usermodel.HSSFName.getReference
(HSSFName.java:142)
at TestSimpleForm.main(TestSimpleForm.java:49)
I also found the error caused by field_2_index_to_first_supbook_sheet, inside
in ExternSheetSubRecord, which is larger than arraylist's size.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org