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]
