Hi Chandra, thank U very much for your answer, I saw U had been the same pb some time ago, I'm very lucky you're online. But I'm a little bit scared to modify the parsing, it seems to me pretty tricky, and I wonder if U remember the way U did that ? Did U recompile POI, or just called a setParser method ? Or would U have some lines of code ? I know it is not veru kind to ask for code, but I'm really under water....
Have a nice day Thy ----- Original Message ----- From: "Nishant Chandra" <[EMAIL PROTECTED]> To: "POI Users List" <[email protected]> Sent: Thursday, December 08, 2005 1:22 PM Subject: Re: Remote reference formula support 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/ --------------------------------------------------------------------- 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/
