A bug or unimplemented PTG structure in the formula parser.
Daniel Noll wrote:
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
--
Andrew C. Oliver
SuperLink Software, Inc.
Java to Excel using POI
http://www.superlinksoftware.com/services/poi
Commercial support including features added/implemented, bugs fixed.
---------------------------------------------------------------------
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/
