SpreadsheetTabSelectorOptions.Visibility Property
Gets or sets a value that indicates whether the Sheet Tab Selector of the SpreadsheetControl should be displayed or hidden.
Namespace: DevExpress.XtraSpreadsheet
Assembly: DevExpress.XtraSpreadsheet.v23.2.dll
NuGet Package: DevExpress.Win.Spreadsheet
Declaration
Property Value
| Type | Description |
|---|---|
| SpreadsheetElementVisibility | A SpreadsheetElementVisibility enumeration value that specifies the visibility of the Sheet Tab Selector. |
Available values:
| Name | Description |
|---|---|
| Default | The element of the SpreadsheetControl is hidden or displayed as specified by the workbook display options. |
| Visible | The element of the SpreadsheetControl is always displayed. |
| Hidden | The element of the SpreadsheetControl is always hidden. |
Property Paths
You can access this nested property as listed below:
| Object Type | Path to Visibility |
|---|---|
| SpreadsheetControlOptions |
|
Remarks
The Visibility property only specifies the way a document is displayed in the SpreadsheetControl (with or without the Sheet Tab Selector) and does not change a workbook file.
The image below shows the appearance of the SpreadsheetControl when the Sheet Tab Selector is hidden.
Note that even if the Sheet Tab Selector is hidden, you can still switch between worksheets by using the keyboard shortcuts. Press CTRL+PAGE DOWN to move to the next worksheet in the current document, or CTRL+PAGE UP to move to the previous worksheet in the workbook.
Note
Currently, the SpreadsheetElementVisibility.Default value has no effect on the visual appearance of the SpreadsheetControl - Sheet Tab Selector will be always displayed despite the settings of the loaded document.