SpreadsheetControl.RowsInserted Event
Occurs after new rows have been added to a worksheet via the SpreadsheetControl‘s UI.
Namespace: DevExpress.XtraSpreadsheet
Assembly: DevExpress.XtraSpreadsheet.v24.1.dll
NuGet Package: DevExpress.Win.Spreadsheet
Declaration
Event Data
The RowsInserted event's data class is RowsChangedEventArgs. The following properties provide information specific to this event:
| Property | Description |
|---|---|
| Count | Gets the number of columns inserted or removed. Inherited from ColumnsChangedEventArgs. |
| StartIndex | Gets the index of the first column after which the columns are inserted or removed. Inherited from ColumnsChangedEventArgs. |
Remarks
Handle the RowsInserted event to perform specific actions each time an end-user inserts new rows into a worksheet via the control’s UI. After rows have been deleted from a worksheet, the SpreadsheetControl.RowsRemoved event is raised.
The SpreadsheetControl.ColumnsInserted and SpreadsheetControl.ColumnsRemoved events are raised on inserting and removing columns via the control’s UI, respectively.
Note
By default, the RowsInserted event does not occur when inserting rows 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.