Spread for ASP.NET 11 Product Documentation
HorizontalScrollBarPolicy Property
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > FpSpread Class : HorizontalScrollBarPolicy Property
Gets or sets whether and how the Spread component displays the horizontal scroll bar.
Syntax
'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;
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
See Also

Reference

FpSpread Class
FpSpread Members
ScrollBarPolicy Enumeration
VerticalScrollBarPolicy Property

User-Task Documentation

Displaying Scroll Bars