Gets or sets whether and how the Spread component displays the horizontal scroll bar.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property HorizontalScrollBarPolicy As ScrollBarPolicy |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As FpSpread
Dim value As ScrollBarPolicy
instance.HorizontalScrollBarPolicy = value
value = instance.HorizontalScrollBarPolicy |
Property Value
ScrollBarPolicy setting that determines the display of the scroll bars
Remarks
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.
| C# | Copy Code |
|---|
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;
|
| Visual Basic | Copy Code |
|---|
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
|
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also
