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


In This Topic
    HorizontalScrollBarPolicy Property
    In This Topic
    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