Programmatically setting Formulas

[Thanvir Hussain]

Hi,
How can I programmatically set formulas to a cell. I want to put a formula which will refer another cell during initialization of the grid.

thanks
thanvir

[Administrator]

In a GridControl, you can use code like this to set a formula into a cell:

//make cell C4 be the sum of A1 and B1.
grid[4,3].CellType = "FormulaCell";
grid[4, 3].Text = "= A1 + B1";