Well i think this is a bug. I solved this problem by modifying the way the formula is parsed.
Nishant On 12/8/05, Thy <[EMAIL PROTECTED]> wrote: > 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/ > > -- Website: www.cse.iitb.ac.in/~nishantc I thought that I had no time for faith nor time to pray, then I saw an armless man saying his Rosary with his feet. --------------------------------------------------------------------- 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/
