Hi.
On a couple of spreadsheets, I'm getting the following stack trace from
getCellFormula(). These are both spreadsheets which appear to have
links to external sheets, which is probably highly relevant information.
Caused by: java.lang.IndexOutOfBoundsException: Index: 3, Size: 1
at java.util.ArrayList.RangeCheck(ArrayList.java:547)
at java.util.ArrayList.get(ArrayList.java:322)
at org.apache.poi.hssf.model.Workbook.getSheetName(Workbook.java:522)
at
org.apache.poi.hssf.model.Workbook.findSheetNameFromExternSheet(Workbook.java:1783)
at
org.apache.poi.hssf.model.Workbook.getSheetReferences(Workbook.java:1766)
at
org.apache.poi.hssf.record.formula.Ref3DPtg.toFormulaString(Ref3DPtg.java:161)
at
org.apache.poi.hssf.model.FormulaParser.toFormulaString(FormulaParser.java:844)
at
org.apache.poi.hssf.model.FormulaParser.toFormulaString(FormulaParser.java:826)
at
org.apache.poi.hssf.usermodel.HSSFCell.getCellFormula(HSSFCell.java:621)
I can obviously just catch Exception around my call to getCellFormula(),
but does anybody else have a better idea of what causes this error?
Daniel
--
Daniel Noll
Nuix Australia Pty Ltd
Suite 79, 89 Jones St, Ultimo NSW 2007, Australia
Phone: (02) 9280 0699
Fax: (02) 9212 6902
This message is intended only for the named recipient. If you are not
the intended recipient you are notified that disclosing, copying,
distributing or taking any action in reliance on the contents of this
message or attachment is strictly prohibited.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
