SpreadsheetControl.ColumnsRemoved Event

Occurs after columns have been deleted from a worksheet via the SpreadsheetControl‘s UI.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v21.2.dll


public event ColumnsRemovedEventHandler ColumnsRemoved

Event Data

The ColumnsRemoved 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 ColumnsRemoved event to perform specific actions each time an end-user removes columns from a worksheet via the control’s UI. After new columns have been added to a worksheet, the SpreadsheetControl.ColumnsInserted event is raised.

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


By default, the ColumnsRemoved event does not occur when removing 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