Thanks a lot... That really works... Is there a way through which I can get the name of the cell?
Regards, Suma ----- Original Message ----- From: [EMAIL PROTECTED] Date: Tuesday, November 18, 2003 12:28 pm Subject: Re: Urgent: setting formulas ..? > On second thoughts, this wont be very difficult. > > Get the formula string from a cell. Parse it thru formula parser > and get the > token array. Check the class of each token, if they are > ReferencePtg's or > AreaReferencePtg's , then change the reference in them. The Ptgs > will have > methods to get the row and col, and will also tell u if the > reference is > absolute or relative ($A1 vs A1) .. so its quite simple. Finally, > transform the > array to a string, and set it to the new cell.. > > So you should be able to do this easily > > Regards > - > Avik > > > Quoting Suma G Shanthappa <[EMAIL PROTECTED]>: > > > > > Is there no other way other than manually parsing the formula? > > Parsing formula manually can be done for the formula that is known.. > > How do I parse if I don't know what kind of formulas can be > present in > > XLS sheet. > > I am parsing an XLS sheet where I only know that there are some > > formulas.. but don't really know what kind of formulas can be > present > > in the sheet. > > Can somebody help me on this? > > > > Regards, > > Suma > > > > > > ----- Original Message ----- > > From: Danny Mui <[EMAIL PROTECTED]> > > Date: Monday, November 17, 2003 9:13 pm > > Subject: Re: Urgent: setting formulas ..? > > > > > I do not believe we shift the cell values when you reassign > cell > > > formulas. You're going to have to update the cell references > > > manually > > > when you set the new formula through string manipulation. > > > > > > prashant neginahal wrote: > > > > > > >Hi All, > > > >I am facing problem in setting formulas to different cells. > > > >Lets say for C2 cell already set formula is > SUM(A1:B1)/SUM(A1:A2).> > >In programme i know this cell has > formula and i want to set this > > > to > > > >another cell C3. Using getCellFormula() i will retrieve the > C2 > > > cell > > > >formula and set it to C3, and now formula for C3 should be > > > >SUM(A2:B2)/SUM(A2:A3). > > > >How this changing of formula can be achieved using POI? > > > >This is urgent, please somebody guide me. > > > > > > > >Regards, > > > >Prashant > > > > > > > > > > > >Yahoo! India Mobile: Ringtones, Wallpapers, Picture Messages > and > > > more.Download now. > > > > > > > > > > > > > > > > > --------------------------------------------------------------- > ---- > > > -- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > ----------------------------------------------------------------- > ---- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > ------------------------------------------------------------------- > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
