Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

SpreadsheetControl.ColumnsRemoved Event

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

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v24.2.dll

NuGet Package: DevExpress.Win.Spreadsheet

#Declaration

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.

#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.

See Also