SpreadsheetControl.ActiveChartSheet Property

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

Namespace: DevExpress.Xpf.Spreadsheet

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


public ChartSheet ActiveChartSheet { get; }

Property Value

Type Description

A ChartSheet object that specifies the active chart sheet.


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