SpreadsheetControl.ColumnsRemoved Event
Occurs after columns have been deleted from a worksheet via the SpreadsheetControl‘s UI.
Namespace: DevExpress.XtraSpreadsheet
Assembly: DevExpress.XtraSpreadsheet.v24.1.dll
NuGet Package: DevExpress.Win.Spreadsheet
Declaration
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. |
Remarks
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.
Note
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.