Hi. I'm trying to read an Excel spreadsheet that has references to other sheets
in the same workbook. References to cells on my current sheet work fine, but
when I try to evaluate one of these references to another sheet I get the
following exception:
java.lang.StringIndexOutOfBoundsException: String index out of range: 0
at java.lang.String.charAt(String.java:444)
at org.apache.poi.hssf.util.CellReference.<init>(CellReference.java:44)
at
org.apache.poi.hssf.record.formula.ReferencePtg.<init>(ReferencePtg.java:50)
at org.apache.poi.hssf.model.FormulaParser.Ident(FormulaParser.java:292)
at
org.apache.poi.hssf.model.FormulaParser.Factor(FormulaParser.java:480)
at org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:569)
at
org.apache.poi.hssf.model.FormulaParser.Expression(FormulaParser.java:617)
at org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:721)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.internalEvaluate(HSSFFormulaEvaluator.java:284)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluate(HSSFFormulaEvaluator.java:181)
I'm using the 3.0 alpha1 jars.
My questions are: Should this work? If not, can I do something like create an
HSSFFormulaEvaluator for the sheet being referenced and then evaluate the cell
on the reference sheet with that evaluator?
Any help is greatly appreciated!
jeff
---------------------------------------------------------------------
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/
