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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
