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 12:41:37 GMT
Thanks a lot... That really works...
Is there a way through which I can get the name of the cell? 

Regards,
Suma

----- Original Message -----
From: avik.sengupta@itellix.com
Date: Tuesday, November 18, 2003 12:28 pm
Subject: Re: Urgent: setting formulas ..?

> 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 <suma.shanthappa@cgi.com>:
> 
> > 
> > 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
> > 
> > 
> 
> 
> 
> 
> 
> -------------------------------------------------------------------
> --
> 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