poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Suma G Shanthappa" <suma.shantha...@cgi.com>
Subject Re: Urgent: setting formulas ..?
Date Tue, 18 Nov 2003 03:23:06 GMT

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 <danny@muibros.com>
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: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


Mime
View raw message