Remember, POI is a file format reader/writer, not yeta functional replacement for Excel.
Having said that, this is probably a good opportunity for someone to make a significant contribution to POI! It not the easiest of problems. Also, there is no reason why you cannot parse a formula that isnt known a-priori. You will get a handle to it at runtime, and can indeed process it whichever way you want. 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]
