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]
