.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

WorksheetVisibilityType Enum

Contains the values that specify worksheet visibility.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

[Flags]
public enum WorksheetVisibilityType
<Flags>
Public Enum WorksheetVisibilityType
[Flags]
public enum WorksheetVisibilityType
<Flags>
Public Enum WorksheetVisibilityType
[Flags]
public enum WorksheetVisibilityType
<Flags>
Public Enum WorksheetVisibilityType

Members

Name Description
Hidden

A worksheet is hidden.

VeryHidden

A worksheet is hidden and cannot be unhidden via the user interface.

Visible

A worksheet is visible.

Remarks

This enumeration's values are used by the Worksheet.VisibilityType property.

Examples

This example demonstrates how to manage worksheet visibility in a workbook. To do this, use the following properties.

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;
See Also