Back to Devexpress

ChartSheet Members

officefileapi-devexpress-dot-spreadsheet-dot-chartsheet-dot-underscore-members.md

latest5.3 KB
Original Source

ChartSheet Members

A separate sheet in a workbook that contains only a chart.

Properties

NameDescription
ActiveViewProvides access to an object that contains options to display and print a chart sheet.
ChartProvides access to the chart on the current chart sheet.
CodeNameGets or sets the chart sheet’s code name.
HeaderFooterOptionsProvides access to options which determine the chart sheet header and footer characteristics.
IdReturns the sheet’s unique identifier. Inherited from Sheet.
IndexGets the chart sheet index within the workbook’s ChartSheetCollection collection.
IsProtectedGets a value indicating whether the chart sheet is protected.
NameGets or sets the name of the chart sheet.
PrintOptionsProvides access to options that control how the chart sheet is printed.
SheetTypeReturns the type of the sheet. Inherited from Sheet.
TagGets or sets the data associated with a ChartSheet object.
VisibilityTypeGets or sets whether the current chart sheet is visible, hidden or “very hidden”.
VisibleGets or sets a value indicating whether the current chart sheet is visible.
WorkbookGets a workbook that contains the current chart sheet.

Methods

NameDescription
CopyFrom(ChartSheet)Copies the specified chart sheet into the current instance.
GetProtectionOptions()Returns the chart sheet elements to which protection is applied.
Move(Int32)Moves the chart sheet to another location within the workbook’s collection of chart sheets.
MoveAfter(String)Moves the current sheet after the specified sheet in a workbook. Inherited from Sheet.
MoveBefore(String)Moves the current sheet before the specified sheet in a workbook. Inherited from Sheet.
MoveToBeginning()Moves the current sheet to the first position in a workbook. Inherited from Sheet.
MoveToEnd()Moves the current sheet to the last position in a workbook. Inherited from Sheet.
Print()Prints the current sheet using the default printer settings. Inherited from Sheet.
Print(DXPrinterSettings)Prints the current sheet using the specified printer settings. Use this method overload in non-Windows environments. Inherited from Sheet.
Print(PrinterSettings)Prints the current sheet using the specified printer settings. Inherited from Sheet.
Protect(String, ChartSheetProtection)Protects chart sheet elements to prevent them from being changed by the user.
Unprotect(String)Removes protection from a chart sheet.

See Also

ChartSheet Interface

DevExpress.Spreadsheet Namespace