Hi all,
cell.setCellFormula(AC129+$Sheet1.AC131)
Seems not to work cause of the '$' reference sign.
Tried cell.setCellFormula(AC129+Sheet1!AC131) too, but same result
throwing String index out of range: 0
I really don't understand whet happens.
I didn't 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.
And this formula works fine under Excel.
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)
---------------------------------------------------------------------
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/
