SpreadsheetScrollbarOptions.Visibility Property

Gets or sets a value that indicates whether the SpreadsheetControl’s scrollbar should be displayed or hidden.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v19.2.dll

Declaration

C#

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

VB.NET

<XtraSerializableProperty>
Public Property Visibility As SpreadsheetScrollbarVisibility

Property Value

Type	Description
SpreadsheetScrollbarVisibility	One of the SpreadsheetScrollbarVisibility enumeration values.

Available values:

Name	Description
Auto	The scrollbar is hidden or displayed depending on the workbook display options.
Visible	The scrollbar is always displayed.
Hidden	The scrollbar is always hidden.

Property Paths

You can access this nested property as listed below:

Object Type	Path to Visibility
SpreadsheetControlOptions	.HorizontalScrollbar.Visibility

Remarks

Use the Visibility property to control the visibility of the horizontal and vertical scrollbars in the SpreadsheetControl. Note that this property only specifies the way a document is displayed in the SpreadsheetControl and does not change a workbook file.

Note

Currently, the SpreadsheetScrollbarVisibility.Auto value has no effect on the visual appearance of the SpreadsheetControl - both horizontal and vertical scrollbars will be displayed despite the settings of the loaded document.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Visibility property.

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.

C#

how-to-display-a-custom-control-over-the-worksheet-cell-t208764/CS/SpreadsheetCustomization/Form1.cs#L31

spreadsheetControl1.Options.Behavior.Selection.AllowExtendSelection = false;
spreadsheetControl1.Options.VerticalScrollbar.Visibility = DevExpress.XtraSpreadsheet.SpreadsheetScrollbarVisibility.Hidden;
spreadsheetControl1.Options.HorizontalScrollbar.Visibility = DevExpress.XtraSpreadsheet.SpreadsheetScrollbarVisibility.Hidden;

how-to-display-custom-controls-instead-of-the-standard-cell-editor-t259398/CS/SpreadsheetCustomization/Form1.cs#L39

spreadsheetControl1.Options.Behavior.Drag = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled;
spreadsheetControl1.Options.VerticalScrollbar.Visibility = DevExpress.XtraSpreadsheet.SpreadsheetScrollbarVisibility.Hidden;
spreadsheetControl1.Options.HorizontalScrollbar.Visibility = DevExpress.XtraSpreadsheet.SpreadsheetScrollbarVisibility.Hidden;

VB.NET

how-to-display-a-custom-control-over-the-worksheet-cell-t208764/VB/SpreadsheetCustomization/Form1.vb#L30

spreadsheetControl1.Options.Behavior.Selection.AllowExtendSelection = False
spreadsheetControl1.Options.VerticalScrollbar.Visibility = DevExpress.XtraSpreadsheet.SpreadsheetScrollbarVisibility.Hidden
spreadsheetControl1.Options.HorizontalScrollbar.Visibility = DevExpress.XtraSpreadsheet.SpreadsheetScrollbarVisibility.Hidden

how-to-display-custom-controls-instead-of-the-standard-cell-editor-t259398/VB/SpreadsheetCustomization/Form1.vb#L41

spreadsheetControl1.Options.Behavior.Drag = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled
spreadsheetControl1.Options.VerticalScrollbar.Visibility = DevExpress.XtraSpreadsheet.SpreadsheetScrollbarVisibility.Hidden
spreadsheetControl1.Options.HorizontalScrollbar.Visibility = DevExpress.XtraSpreadsheet.SpreadsheetScrollbarVisibility.Hidden