Skip to main content
Row

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

ChartSheet.ActiveView Property

Provides access to an object that contains options to display and print a chart sheet.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

ChartSheetView ActiveView { get; }

#Property Value

Type Description
ChartSheetView

A ChartSheetView object.

#Remarks

Use the ChartSheetView object’s members to zoom a chart sheet (ChartSheetView.Zoom and ChartSheetView.ZoomToFit), select a sheet tab color (ChartSheetView.TabColor), and change print settings (ChartSheetView.Orientation, ChartSheetView.Margins and ChartSheetView.PaperKind). To access more print-specific options, use the ChartSheetPrintOptions object returned by the ChartSheet.PrintOptions property.

#Example

View Example

Worksheet worksheet = workbook.Worksheets["chartTask1"];
workbook.Unit = DevExpress.Office.DocumentUnit.Inch;

// Create a chart sheet containing a pie chart.
ChartSheet chartSheet = workbook.ChartSheets.Add(ChartType.Pie, worksheet["B2:C7"]);

// Specify print settings.
chartSheet.ActiveView.Orientation = PageOrientation.Landscape;
chartSheet.ActiveView.PaperKind = DevExpress.Drawing.Printing.DXPaperKind.Letter;

// Specify page margins.
Margins pageMargins = chartSheet.ActiveView.Margins;
pageMargins.Left = 0.7F;
pageMargins.Top = 0.75F;
pageMargins.Right = 0.7F;
pageMargins.Bottom = 0.75F;

workbook.ChartSheets.ActiveChartSheet = chartSheet;
See Also