Workbook.SelectionChanged Event

Fires when the selection changes in a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Docs.v24.1.dll

NuGet Package: DevExpress.Document.Processor

Declaration

C#

public event EventHandler SelectionChanged

VB.NET

Public Event SelectionChanged As EventHandler

Event Data

The SelectionChanged event's data class is EventArgs.

Remarks

Handle the SelectionChanged event to perform any actions each time the selection changes in a worksheet. Use the following API members to specify the selection in code:

• Worksheet.SelectedCell - specifies an active cell.

• Worksheet.Selection - specifies the continuous range of selected cells.

• Worksheet.SetSelectedRanges - allows you to select multiple non-adjacent cell ranges.

• Worksheet.SelectedChart - specifies the selected chart.

• Worksheet.SelectedPicture - specifies the selected picture.

• Worksheet.SelectedShape - specifies the selected drawing object.

• Worksheet.SetSelectedShapes - allows you to select multiple drawing objects.

Set the WorkbookEventOptions.RaiseOnModificationsViaAPI property to true to raise the SelectionChanged event when the selection is changed in code. Handle the SelectionChanged event of the WinForms Spreadsheet or WPF Spreadsheet control to perform any actions when a user selects cells, rows, columns, or drawing objects in the control’s UI.

Implements

SelectionChanged