Hi Nishant, sorry to be so late, I had to travel to England up to now without having easy web access. So I apologize and wonder if you found your sample code by this week end, it could really help me. Thy
----- Original Message ----- From: "Nishant Chandra" <[EMAIL PROTECTED]> To: "POI Users List" <[email protected]> Sent: Thursday, December 08, 2005 3:07 PM Subject: Re: Remote reference formula support i can do it by this weekend.is that ok? Nishant On 12/8/05, Thierry Morel <[EMAIL PROTECTED]> wrote: > Thank U again Chandra for taking time for this. > I'm already late in fact... but I have no choice... > I just have to explain that to my boss ! > How much time do U need to get your code back on your side ? > Thy > > > 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/ > > > > --------------------------------------------------------------------- > 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/
