Hi, well i modified 3-4 files which handles parsing and deals with low level record generation for formulas. I have the code but its not immediately accesible to me. i dont rem xactly what i did cos its been some time now. how much time do u have?
nishant On 12/8/05, Thierry Morel <[EMAIL PROTECTED]> wrote: > 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/ > > -- 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/
