Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / ScrollBarShowMax Property
Example


In This Topic
    ScrollBarShowMax Property (FpSpread)
    In This Topic
    Gets or sets whether the displayed scroll bars are based on the entire number of columns and rows in the sheet.
    Syntax
    'Declaration
     
    Public Property ScrollBarShowMax As Boolean
    'Usage
     
    Dim instance As FpSpread
    Dim value As Boolean
     
    instance.ScrollBarShowMax = value
     
    value = instance.ScrollBarShowMax
    public bool ScrollBarShowMax {get; set;}

    Property Value

    Boolean: true if user can scroll through the entire spreadsheet; false otherwise
    Remarks

    When this property is true (which is the default), the scroll bar allows the end user to scroll the entire view.

    When this property is false, the scroll bar allows the end user to scroll the view up to the last row or column with data. This option provides scroll bars for very large spreadsheets that have only a small amount of the sheet used for data, so the scroll bars can be based on the rows and columns with data rather than the total number of rows and columns possible.

    Example
    This example specifies several aspects of the scroll bars for the Spread component. Scroll bars appear larger than the default size. For scrolling horizontally, the spreadsheet scrolls as you move the scroll box; for scrolling vertically, the scroll bar tip shows the row number, but the spreadsheet does not scroll until you are done.
    FarPoint.Win.Spread.FpSpread fpSpread1 = new FarPoint.Win.Spread.FpSpread();
    FarPoint.Win.Spread.SheetView shv = new FarPoint.Win.Spread.SheetView();
    fpSpread1.Location = new Point(10, 10);
    fpSpread1.Height = 250;
    fpSpread1.Width = 400;
    Controls.Add(fpSpread1);
    fpSpread1.Sheets.Add(shv);
    fpSpread1.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.Always;
    fpSpread1.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
    fpSpread1.HorizontalScrollBarHeight = 30;
    fpSpread1.VerticalScrollBarWidth = 30;
    fpSpread1.ScrollBarMaxAlign = true;
    fpSpread1.ScrollBarShowMax = true;
    fpSpread1.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Horizontal;
    fpSpread1.ScrollTipPolicy = FarPoint.Win.Spread.ScrollTipPolicy.Vertical;
    
    Dim fpSpread1 As New FarPoint.Win.Spread.FpSpread()
    Dim shv As New FarPoint.Win.Spread.SheetView()
    fpSpread1.Location = New Point(10, 10)
    fpSpread1.Height = 250
    fpSpread1.Width = 400
    Controls.Add(fpSpread1)
    fpSpread1.Sheets.Add(shv)
    fpSpread1.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.Always
    fpSpread1.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded
    fpSpread1.HorizontalScrollBarHeight = 30
    fpSpread1.VerticalScrollBarWidth = 30
    fpSpread1.ScrollBarMaxAlign = True
    fpSpread1.ScrollBarShowMax = True
    fpSpread1.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Horizontal
    fpSpread1.ScrollTipPolicy = FarPoint.Win.Spread.ScrollTipPolicy.Vertical
    
    See Also