VerticalScrollBarPolicy Property

Gets or sets whether and how the Spread component displays the vertical scroll bar.

Syntax

Visual Basic
C#

'Declaration
 
Public Property VerticalScrollBarPolicy As ScrollBarPolicy

'Usage
 
Dim instance As FpSpread
Dim value As ScrollBarPolicy
 
instance.VerticalScrollBarPolicy = value
 
value = instance.VerticalScrollBarPolicy

public ScrollBarPolicy VerticalScrollBarPolicy {get; set;}

Property Value

ScrollBarPolicy setting that determines the display of the scroll bars

Remarks

Specify the settings for the horizontal scroll bars by setting the HorizontalScrollBarPolicy property.

Example

This example creates a sheet with 3 columns and 50 rows. The scroll bar policy (both Horizontal and Veritcal) is set to As Needed, so the horizonal scroll bar is not visible, since it is not needed with only 3 columns. The vertical scroll bar is displayed because 50 rows is more than can be displayed.

FpSpread1.ActiveSheetView.ColumnCount = 3;
FpSpread1.ActiveSheetView.PageSize = 50;
FpSpread1.ActiveSheetView.RowCount = 50;
FpSpread1.HorizontalScrollBarPolicy = FarPoint.Web.Spread.ScrollBarPolicy.AsNeeded;
FpSpread1.VerticalScrollBarPolicy = FarPoint.Web.Spread.ScrollBarPolicy.AsNeeded;

Visual Basic

FpSpread1.ActiveSheetView.ColumnCount = 3
FpSpread1.ActiveSheetView.PageSize = 50
FpSpread1.ActiveSheetView.RowCount = 50
FpSpread1.HorizontalScrollBarPolicy = FarPoint.Web.Spread.ScrollBarPolicy.AsNeeded
FpSpread1.VerticalScrollBarPolicy = FarPoint.Web.Spread.ScrollBarPolicy.AsNeeded

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

FpSpread Class
FpSpread Members
ScrollBarPolicy Enumeration
HorizontalScrollBarPolicy Property

User-Task Documentation

Displaying Scroll Bars