Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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.v24.2.dll

NuGet Package: DevExpress.Win.Spreadsheet

#Declaration

[XtraSerializableProperty]
public SpreadsheetElementVisibility Visibility { get; set; }

#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
.TabSelector .Visibility

#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.

SpreadsheetControl_SheetTabSelectorHidden

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.

See Also