poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Kays" <Jeff.K...@onvoy.com>
Subject problem evaluating reference to another sheet
Date Fri, 07 Jul 2006 19:38:55 GMT
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: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Mime
View raw message