Dynamically calculate cell values

[Dirk LX]

Dear everybody,

my request is it to dynamically calculate cell values.

I feed my RadGridView with a dataset or datareader. I am looking for an event which gets fired while data is bounded. The method shall allow me to modify the current cell value based on a calculation of other cells. Something similar like excel also provides with the formula stuff.

Is there any way you can help me?

I also tried events like cellvaluechanged, cellvalidation,valuechanging and the other stuff.

Thanks for a quick reply.

best,

[Martin Vasilev]

Hi Dirk LX,

Thank you for the question.

You have two options to implement dynamically calculated values: Using Calculated Columns (Column Expressions) or using CellFormatting event. You can find a working sample of how to use expressions in our Examples application under Grid View >> Columns >> Expressions. You can change the cell value in CellFormatting event as it is shown in the following code snippet:

void radGridView1_CellFormatting(object sender, CellFormattingEventArgs e)
{
    if (e.CellElement.ColumnIndex == 6)
    {
        e.CellElement.Text = (Convert.ToInt32(e.CellElement.Text) + 1000).ToString();
    }
}

Do not hesitate to contact me again if you have any other questions.

Sincerely yours,
Martin Vasilev
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.