SpreadsheetControl.RowsInserting Event

Occurs when new rows are about to be inserted into a worksheet.

Namespace: DevExpress.Xpf.Spreadsheet

Assembly: DevExpress.Xpf.Spreadsheet.v24.1.dll

NuGet Package: DevExpress.Wpf.Spreadsheet

Declaration

C#

public event RowsChangingEventHandler RowsInserting

VB.NET

Public Event RowsInserting As RowsChangingEventHandler

Event Data

The RowsInserting event's data class is RowsChangingEventArgs. 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 RowsInserting event allows you to perform any actions before an end-user adds new rows using the control’s UI. You can cancel inserting new rows by setting the event parameter’s Cancel property to true.

After new rows have been inserted, the SpreadsheetControl.RowsInserted event is raised.