Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

SpreadsheetControl.ActiveSheetChanging Event

Occurs when an active worksheet in a workbook is about to be changed.

Namespace: DevExpress.Xpf.Spreadsheet

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

NuGet Package: DevExpress.Wpf.Spreadsheet

#Declaration

public event ActiveSheetChangingEventHandler ActiveSheetChanging

#Event Data

The ActiveSheetChanging event's data class is ActiveSheetChangingEventArgs. The following properties provide information specific to this event:

Property Description
Cancel Gets or sets whether the changing the active sheet should be canceled.
NewActiveSheetName Gets the name of the new active worksheet. Inherited from ActiveSheetChangeEventArgsBase.
OldActiveSheetName Gets the name of the old active worksheet. Inherited from ActiveSheetChangeEventArgsBase.

#Remarks

The ActiveSheetChanging event allows you to perform any actions before an active worksheet is changed. You can cancel changing the active worksheet by setting the event parameter’s Cancel property to true.

After an active worksheet has been changed, the SpreadsheetControl.ActiveSheetChanged event is raised.

When a worksheet is removed from the workbook, the ActiveSheetChanging event does not occur, although the SpreadsheetControl.ActiveSheetChanged event is fired.

See Also