Skip to main content
Row

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.1.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