poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Danny Mui <da...@muibros.com>
Subject Re: Urgent: setting formulas ..?
Date Mon, 17 Nov 2003 15:43:20 GMT
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


Mime
View raw message