Hi all,
exactly the same pb as Chandra with cell.setCellFormula(AC129+$Sheet1.AC131)
but not found any answer through the web for hours...
I've found many similar posts but no solution.
Is there any solution ?
I've tried with Poi2.5, 2.5.1 and 3.0alpha, no difference.
Thank U very much in advance for a tip !
Thy
StackTrace :
java.lang.StringIndexOutOfBoundsException: String index out of range: 0
at java.lang.String.charAt(String.java:558)
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:291)
at org.apache.poi.hssf.model.FormulaParser.Factor
(FormulaParser.java:474)
at org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:548)
at org.apache.poi.hssf.model.FormulaParser.Add(FormulaParser.java:562)
at org.apache.poi.hssf.model.FormulaParser.Expression
(FormulaParser.java:598)
at org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:700)
at org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula
(HSSFCell.java:678)
Nishant Chandra <nishant.chandra <at> gmail.com> writes:
---------------------------------------------------------------------
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/
