SpreadsheetControl.ColumnsRemoved Event

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

Namespace : DevExpress.XtraSpreadsheet

Assembly : DevExpress.XtraSpreadsheet.v25.2.dll

NuGet Package : DevExpress.Win.Spreadsheet

Declaration

C#
VB.NET

csharp

public event ColumnsRemovedEventHandler ColumnsRemoved

Public Event ColumnsRemoved As ColumnsRemovedEventHandler

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.