wpf-devexpress-dot-xpf-dot-spreadsheet-dot-spreadsheetcontrol-5370422a.md
Occurs when new columns are about to be inserted into a worksheet.
Namespace : DevExpress.Xpf.Spreadsheet
Assembly : DevExpress.Xpf.Spreadsheet.v25.2.dll
NuGet Package : DevExpress.Wpf.Spreadsheet
public event ColumnsChangingEventHandler ColumnsInserting
Public Event ColumnsInserting As ColumnsChangingEventHandler
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. |
The ColumnsInserting event allows you to perform any actions before an end-user adds new columns using the control’s UI. You can cancel inserting new columns by setting the event parameter’s Cancel property to true.
After new columns have been inserted, the SpreadsheetControl.ColumnsInserted event is raised.
See Also