Skip to main content

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


public event RowsInsertedEventHandler RowsInserted

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.


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.


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.

See Also