Grid - Registered Users - Helpdesk
Relative Cell references in Formula
Thread Starter: Sri Started: 7/30/2008 11:24 AM UTC
Replies: 1
7/30/2008 11:24 AM UTC
Relative Cell references in Formula
Reply Quote

Sri

How do i programatically insert Formula with Relative cell reference into a column?

For I := 2 to pg.rowcount-2 do
   pg.cells[5,i].formula := '$K2 * 2.5';

this code just insert K2*2.5 into all rows.

Please help .


Sri
8/30/2008 6:34 PM UTC
Re: Relative Cell references in Formula
Reply Quote

profgrid.com

Hello Sri:

For I := 2 to pg.rowcount-2 do
   pg.cells[5,i].formula := '$K' + IntToStr(I) + ' * 2.5';


-Nicholas