ScrollBarMaxAlign Property (SpreadView)

Gets or sets the scroll bar alignment with the last row and column of the spreadsheet in the view.

Syntax

Visual Basic
C#

'Declaration
 
Public Property ScrollBarMaxAlign As Boolean

'Usage
 
Dim instance As SpreadView
Dim value As Boolean
 
instance.ScrollBarMaxAlign = value
 
value = instance.ScrollBarMaxAlign

public bool ScrollBarMaxAlign {get; set;}

Property Value

Boolean: true if scroll bar aligns with the last row and column of the spreadsheet; false otherwise

Example

This example sets the ScrollBarMaxAlign property.

FarPoint.Win.Spread.SpreadView sv = fpSpread1.GetRootWorkbook();
sv.HorizontalScrollBarHeight = 10;
sv.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.Both
sv.ScrollBarMaxAlign = false;
sv.ScrollBarShowMax = true;
sv.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Vertical;
sv.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
sv.VerticalScrollBarWidth = 15;

VB.NET

Dim sv As FarPoint.Win.Spread.SpreadView = FpSpread1.GetRootWorkbook
sv.HorizontalScrollBarHeight = 10
sv.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded
sv.ScrollBarMaxAlign = False
sv.ScrollBarShowMax = True
sv.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Vertical
sv.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded
sv.VerticalScrollBarWidth = 15

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

SpreadView Class
SpreadView Members

User-Task Documentation

Customizing the Scroll Bars