Spread ASP.NET 15
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FpSpread Class / HorizontalScrollBarPolicy Property

In This Topic
    HorizontalScrollBarPolicy Property
    In This Topic
    Gets or sets whether and how the Spread component displays the horizontal scroll bar.
    Public Property HorizontalScrollBarPolicy As ScrollBarPolicy
    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

    Specify the settings for the vertical scroll bars by setting the VerticalScrollBarPolicy property.

    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