Workbook.ColumnsInserting Event
Occurs before new columns are added to a worksheet.
You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Docs.v24.1.dll
NuGet Package: DevExpress.Document.Processor
Declaration
Event Data
The ColumnsInserting event's data class is ColumnsChangingEventArgs. The following properties provide information specific to this event:
| Property | Description |
|---|---|
| Cancel | Gets or sets a value indicating whether the event should be canceled. Inherited from CancelEventArgs. |
| Count | Gets the number of rows/columns that will be inserted or removed. Inherited from RowsColumnsChangingEventArgsBase. |
| StartIndex | Gets the index of the first row/column after which rows/columns will be inserted or removed. Inherited from RowsColumnsChangingEventArgsBase. |
Remarks
The ColumnsInserting event allows you to perform any actions before new columns are inserted into a worksheet. You can cancel inserting new columns by setting the event parameter’s Cancel property to true.
After new columns have been inserted, the Workbook.ColumnsInserted event is raised.
Note
By default, the ColumnsInserting event does not occur when adding new 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 Workbook.Options.Events.RaiseOnModificationsViaAPI notation) to true.