officefileapi-devexpress-dot-spreadsheet-dot-chartsheet-8f5afae8.md
Provides access to an object that contains options to display and print a chart sheet.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
ChartSheetView ActiveView { get; }
ReadOnly Property ActiveView As ChartSheetView
| Type | Description |
|---|---|
| ChartSheetView |
A ChartSheetView object.
|
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.
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;
Dim worksheet As Worksheet = workbook.Worksheets("chartTask1")
workbook.Unit = DevExpress.Office.DocumentUnit.Inch
' Create a chart sheet containing a pie chart.
Dim chartSheet As 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.
Dim pageMargins As Margins = 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