WorksheetVisibilityType Enum
Contains the values that specify worksheet visibility.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v22.1.Core.dll
Declaration
Members
| 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
This enumeration’s values are used by the Worksheet.VisibilityType property.
Example
This example demonstrates how to manage worksheet visibility in a workbook. To do this, use the following properties.
-
Set this property to false to hide a worksheet. To make a worksheet visible again, you can set the Visible property to true or the Worksheet.VisibilityType property to the WorksheetVisibilityType.Visible enumeration member. End-users can show a hidden worksheet via the user interface (for example, when opening a workbook in Microsoft® Excel® or SpreadsheetControl).
-
Setting this property to WorksheetVisibilityType.Hidden is equivalent to setting the Worksheet.Visible property to false - the hidden worksheet can be shown again by end-users via the user interface (for example, Microsoft® Excel® or SpreadsheetControl).
The VisibilityType property also allows you to hide a worksheet so that it becomes impossible for end-users to access this worksheet. To do this, mark a worksheet as “very hidden” by setting the VisibilityType property to WorksheetVisibilityType.VeryHidden. To show a worksheet again, set the Visible property to true or VisibilityType to WorksheetVisibilityType.Visible.
Note
A workbook must always contain at least one visible worksheet.
// Hide the worksheet under the "Sheet2" name and prevent end-users from unhiding it via user interface.
// To make this worksheet visible again, use the Worksheet.Visible property.
workbook.Worksheets["Sheet2"].VisibilityType = WorksheetVisibilityType.VeryHidden;
// Hide the "Sheet3" worksheet.
// In this state a worksheet can be unhidden via user interface.
workbook.Worksheets["Sheet3"].Visible = false;
Related GitHub Examples
The following code snippets (auto-collected from DevExpress Examples) contain references to the WorksheetVisibilityType enum.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.