SpreadsheetControl.RowsRemoving Event

Occurs when rows are about to be deleted from a worksheet.

Namespace: DevExpress.Xpf.Spreadsheet

Assembly: DevExpress.Xpf.Spreadsheet.v23.2.dll

NuGet Package: DevExpress.Wpf.Spreadsheet

Declaration

C#

public event RowsChangingEventHandler RowsRemoving

VB.NET

Public Event RowsRemoving As RowsChangingEventHandler

Event Data

The RowsRemoving 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 RowsRemoving event allows you to perform any actions before an end-user removes rows from a worksheet using the control’s UI. To prevent rows from being deleted, set the event parameter’s Cancel property to true.

After rows have been removed from a worksheet, the SpreadsheetControl.RowsRemoved event is raised.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the RowsRemoving event.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

XAML

wpf-spreadsheet-bind-spreadsheet-to-ms-sql-server-database/CS/WpfSpreadsheet_BindToDataSource/MainWindow.xaml#L1600

<dxsps:SpreadsheetFormulaBarControl x:Name="formulaBar" SpreadsheetControl="{Binding ElementName=spreadsheetControl}" />
<dxsps:SpreadsheetControl x:Name="spreadsheetControl" BarManager="{Binding ElementName=barManager1, Mode=OneTime}" Ribbon="{Binding ElementName=ribbonControl1, Mode=OneTime}" Grid.Row="1" PreviewMouseLeftButtonDown="spreadsheetControl_PreviewMouseLeftButtonDown" RowsRemoved="spreadsheetControl_RowsRemoved" RowsRemoving="spreadsheetControl_RowsRemoving" >
    <dxsps:SpreadsheetControl.Options>