HorizontalScrollBarPolicy Property

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

Syntax

Visual Basic
C#

'Declaration
 
Public Property HorizontalScrollBarPolicy As ScrollBarPolicy

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

public ScrollBarPolicy HorizontalScrollBarPolicy {get; set;}

Property Value

ScrollBarPolicy setting that determines the display of the scroll bars

Remarks

Specify the settings for the vertical scroll bars by setting the VerticalScrollBarPolicy 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
VerticalScrollBarPolicy Property

User-Task Documentation

Displaying Scroll Bars