Skip to main content

SpreadsheetControl.ColumnsInserted Event

Occurs after new columns have been added to a worksheet via the SpreadsheetControl‘s UI.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v22.2.dll

NuGet Package: DevExpress.Win.Spreadsheet


public event ColumnsInsertedEventHandler ColumnsInserted

Event Data

The ColumnsInserted event's data class is ColumnsChangedEventArgs. The following properties provide information specific to this event:

Property Description
Count Gets the number of columns inserted or removed.
StartIndex Gets the index of the first column after which the columns are inserted or removed.


Handle the ColumnsInserted event to perform specific actions each time an end-user inserts new columns into a worksheet via the control’s UI. After columns have been deleted from a worksheet, the SpreadsheetControl.ColumnsRemoved event is raised.

The SpreadsheetControl.RowsInserted and SpreadsheetControl.RowsRemoved events are raised on inserting and removing rows via the control’s UI, respectively.


By default, the ColumnsInserted event does not occur when inserting columns in code. However, this event will also be triggered by changes made via an API if you set the WorkbookEventOptions.RaiseOnModificationsViaAPI property (accessible via the SpreadsheetControl.Options.Events.RaiseOnModificationsViaAPI notation) to true.

See Also