ChartSheet.VisibilityType Property
Gets or sets whether the current chart sheet is visible, hidden or “very hidden”.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Property Value
| Type | Description |
|---|---|
| WorksheetVisibilityType | A WorksheetVisibilityType enumeration member that specifies the chart sheet visibility type. |
Available values:
| Name | Description |
|---|---|
| Visible | A worksheet is visible. |
| Hidden | A worksheet is hidden. |
| VeryHidden | A worksheet is hidden and cannot be unhidden via the user interface. |
Remarks
Set the VisibilityType property to WorksheetVisibilityType.Hidden to hide the chart sheet. Set it to WorksheetVisibilityType.Visible to show the previously hidden chart sheet again. You can also accomplish this via the ChartSheet.Visible property.
Also, the VisibilityType property provides you with the capability to make the chart sheet “very hidden” (WorksheetVisibilityType.VeryHidden). This is a specific mode that does not allow the chart sheet to be shown again by end-users. To make a “very hidden” chart sheet visible again, set the VisibilityType property to WorksheetVisibilityType.Visible or Worksheet.Visible to true.
If you hide a chart sheet that is currently active, the next visible sheet (a worksheet or chart sheet) to the right of this chart sheet is automatically activated. If there are no visible sheets to the right of the hidden chart sheet, the first visible sheet to the left of this chart sheet becomes active.
Note
A workbook must always contain at least one visible sheet.