or
private void gridExpenses_CellValueChanged(object sender, GridViewCellEventArgs e){ if (e.Column.OwnerTemplate != gridExpenses.MasterTemplate && e.Column.Name == "colAmount") { EvaluateTotal((GridViewRowInfo)e.Row.Parent); }}private void EvaluateTotal(GridViewRowInfo parent){ if (parent.ChildRows.Count > 0) parent.Cells["colRemaining"].Value = gridExpenses.Evaluate("Sum(colAmount)", parent.ChildRows);}
Also, I should export only visible columns in RadGridView and the text columns should be present only in the exported excel file and not to be displayed in RadGridView.
We are using Telerik Control version : 2013.3.1127.40
Regards,
Vimal

public partial class Form1 : RadForm{ public Form1() { InitializeComponent(); this.radGridView1.EditorRequired += radGridView1_EditorRequired; this.radGridView1.CellEditorInitialized += radGridView1_CellEditorInitialized; } void radGridView1_CellEditorInitialized(object sender, GridViewCellEventArgs e) { if (e.ActiveEditor is RadDropDownListEditor) { RadDropDownListEditor editor = e.ActiveEditor as RadDropDownListEditor; RadDropDownListEditorElement element = (RadDropDownListEditorElement)editor.EditorElement; element.DisplayMember = "Description"; element.ValueMember = "Code"; element.DataSource = this.CreateDataTable(); element.SelectedIndex = -1; } } void radGridView1_EditorRequired(object sender, EditorRequiredEventArgs e) { e.EditorType = typeof(RadDropDownListEditor); } private DataTable CreateDataTable() { DataTable dataTable = new DataTable(); dataTable.Columns.Add("Code", typeof(decimal)); dataTable.Columns.Add("Description", typeof(string)); for (int i = 0; i < 5; i++) { DataRow dr = dataTable.NewRow(); dr[0] = i + 1; dr[1] = "Description " + (i + 1); dataTable.Rows.Add(dr); } return dataTable; }}private void gvProducts_ViewCellFormatting(object sender, Telerik.WinControls.UI.CellFormattingEventArgs e) { if (e.CellElement is GridSummaryCellElement) { e.CellElement.TextAlignment = ContentAlignment.BottomRight; e.CellElement.Font = new Font(e.CellElement.Font, FontStyle.Bold); } }