or
private IList<Attribute> _data = new List<Attribute>(); private void bwLoadData_RunWorkerCompleted(object sender, System.ComponentModel.RunWorkerCompletedEventArgs e) { this.grvAttribute1.DataSource = _data; this.grvAttribute1.CellFormatting += insertControls; }Attribute attribute = new Attribute(); private void insertControls(object sender, CellFormattingEventArgs e) { try { if (e.Column.Name == "Type") { if (attribute.Type == 3) { if (e.CellElement.Children.Count == 0) { RadSpinEditor se = new RadSpinEditor(); se.Dock = DockStyle.Fill; se.ShowUpDownButtons = false; se.ThemeName = "TelerikMetro"; se.TextAlignment = HorizontalAlignment.Center; se.DecimalPlaces = 2; se.Minimum = -999999.99M; se.Maximum = 999999.99M; Telerik.WinControls.RadHostItem i = new Telerik.WinControls.RadHostItem(se); e.CellElement.Children.Add(i); } } } } catch (Exception ex) { //message } }private void DataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { var location = Convert.ToString(dataGridView1[e.ColumnIndex, e.RowIndex].Value); if (dataGridView1.Columns[e.ColumnIndex] is DataGridViewLinkColumn) if (e.ColumnIndex == 4) Process.Start(location); else if (e.ColumnIndex == 5) { int i = dataGridView1.CurrentCell.RowIndex;
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; }}