How do I change a formula in a formulaCell type?

[Paul P]

I have a rather complex formula, that I would to be able to change "by hand" when certain conditions occur.

How can I change a formula in a GridControl? If I just reset the .Text, nothing happens

thanks.

-Paul

[SubhaSheela R]

Hi Paul,

Thank you for using Syncfusion products.

You can change the formula programmatically by setting new formula to the Text property of the GridControl . I have created a sample that shows the formula in a cell programmatically. Could you please give me more details about the complex formula, so that I could provide you the exact solution? Or please send us a sample with the issue, we will analyze it and provide you the details.
Below is the code snippet:

            this.gridControl2[2, 3]. Text = "=(A2+B2)";

Please refer the sample available in the link below and let me know if it helps:

http://websamples.syncfusion.com//samples/ Grid.Windows/F71548/main.htm

Regards,
Subhasheela R

[Paul P]

this doesn't work for me.

The complexity of the formula doesn't matter, but this is basically what I do:

in form_load I do:

this.grid[3,3].CellValue = "=sheet2!a1";
this.grid[3,3].CellType = "FormulaCell";

Then I have a timer that does a callback

in the callback after 10 secongs or so I do:
this.grid[3,3].CellValue = "=sheet3!b2";
this.grid[3,3].CellType = "FormulaCell";

but the value in the grid is still the same.
to double check, I even do
this.grid[3,4].CellValue = this.grid[3,3].CellValue
this.grid[3,4].CellType = this.grid[3,3].CellType

and the cell[3,4] actually gets the NEW values, but cell[3,3] keeps the old formula.

[SubhaSheela R]

Hi Paul,

Thank you for using Syncfusion products.

You can clear the fromula cell value in the cell using ClearCells method of GridControl before resetting the formula.
Below is the code snippet:

            this.gridControl2.ClearCells(GridRangeInfo.Cell(3, 4), true);
           if (timer1.Interval == 100)
            {
                this.gridControl2[3, 4].CellType = GridCellTypeName.FormulaCell;
                this.gridControl2[3, 4].Text = "=gridControl2!B9";
            }

Please refer the sample available in the link below and let me know if it helps:

http://websamples.syncfusion.com//samples/Grid.Windows/F71548FollowUp/main.htm

Regards,
Subhasheela R

[Paul P]

Thanks, that worked

[SubhaSheela R]

Hi Paul,

Thanks for your update.

Regards,
Subhasheela R