SpreadsheetControl.ColumnsInserted Event

Occurs after new columns have been added to 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 ColumnsInsertedEventHandler ColumnsInserted

Public Event ColumnsInserted As ColumnsInsertedEventHandler

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.

Remarks

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.

Note

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.