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.ActiveChartSheet Property

Gets the chart sheet that is currently displayed in the SpreadsheetControl.

Namespace: DevExpress.Xpf.Spreadsheet

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

NuGet Package: DevExpress.Wpf.Spreadsheet

#Declaration

[Browsable(false)]
public ChartSheet ActiveChartSheet { get; }

#Property Value

Type Description
ChartSheet

A ChartSheet object that specifies the active chart sheet.

#Remarks

If the currently active sheet in the SpreadsheetControl is a Worksheet, the ActiveChartSheet property returns null (Nothing in VB).

You can also use the SpreadsheetControl.ActiveSheet property to obtain the currently active sheet in a workbook containing both worksheets and chart sheets. The Sheet.SheetType property allows you to get the type of the active sheet.

To specify an active chart sheet in code, use the ChartSheetCollection.ActiveChartSheet or SheetCollection.ActiveSheet property.

An end-user can switch between sheets using the SpreadsheetControl’s Sheet Tab Selector. Before and after an active sheet is changed via the control’s UI, the SpreadsheetControl.ActiveSheetChanging and SpreadsheetControl.ActiveSheetChanged events are raised, respectively.

See Also