Skip to main content
.NET Framework 4.5.2+
Row

WorksheetVisibilityType Enum

Contains the values that specify worksheet visibility.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v22.1.Core.dll

Declaration

[Flags]
public enum WorksheetVisibilityType

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.

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;

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.

See Also