HorizontalScrollBarVisibility Property (GcSpreadSheet)

Gets or sets the horizontal scroll bar visibility setting.

Syntax

Visual Basic
C#

'Declaration
 
<CategoryAttribute()>
<DefaultValueAttribute()>
Public Property HorizontalScrollBarVisibility As ScrollBarVisibility

'Usage
 
Dim instance As GcSpreadSheet
Dim value As ScrollBarVisibility
 
instance.HorizontalScrollBarVisibility = value
 
value = instance.HorizontalScrollBarVisibility

[Category()]
[DefaultValue()]
public ScrollBarVisibility HorizontalScrollBarVisibility {get; set;}

Example

This example uses the HorizontalScrollBarVisibility property.

C#
VB.NET

private void Grid_Loaded_1(object sender, RoutedEventArgs e)
        {
            var style = new Windows.UI.Xaml.Style();
            gcSpreadSheet1.HorizontalScrollBarStyle = style;
            gcSpreadSheet1.VerticalScrollBarStyle = style;
            gcSpreadSheet1.HorizontalScrollBarVisibility = ScrollBarVisibility.Visible;
            gcSpreadSheet1.VerticalScrollBarVisibility = ScrollBarVisibility.Visible;
            gcSpreadSheet1.HorizontalScrollBarHeight = 20;
            gcSpreadSheet1.VerticalScrollBarWidth = 20;
            gcSpreadSheet1.ScrollBarTrackPolicy = GrapeCity.Xaml.SpreadSheet.UI.ScrollBarTrackPolicy.Both;
        }

        private void Button_Click_1(object sender, RoutedEventArgs e)
        {            
            //Uncomment a method to test
            //gcSpreadSheet1.Sheets[0].SetActiveCell(10, 7);
            //gcSpreadSheet1.ShowActiveCell(GrapeCity.Xaml.SpreadSheet.UI.VerticalPosition.Bottom, GrapeCity.Xaml.SpreadSheet.UI.HorizontalPosition.Left);
            //gcSpreadSheet1.ShowCell(0, 0, 20, 10, GrapeCity.Xaml.SpreadSheet.UI.VerticalPosition.Bottom, GrapeCity.Xaml.SpreadSheet.UI.HorizontalPosition.Right);
            //gcSpreadSheet1.ShowColumn(0, 10, GrapeCity.Xaml.SpreadSheet.UI.HorizontalPosition.Nearest);
           gcSpreadSheet1.ShowRow(0, 50, GrapeCity.Xaml.SpreadSheet.UI.VerticalPosition.Center);
        }

Private Sub MainPage_Loaded(sender As Object, e As RoutedEventArgs) Handles Me.Loaded
        Dim style As New Windows.UI.Xaml.Style()
        gcSpreadSheet1.HorizontalScrollBarStyle = style
        gcSpreadSheet1.VerticalScrollBarStyle = style
        gcSpreadSheet1.HorizontalScrollBarVisibility = ScrollBarVisibility.Visible
        gcSpreadSheet1.VerticalScrollBarVisibility = ScrollBarVisibility.Visible
        gcSpreadSheet1.HorizontalScrollBarHeight = 20
        gcSpreadSheet1.VerticalScrollBarWidth = 20
        gcSpreadSheet1.ScrollBarTrackPolicy = GrapeCity.Xaml.SpreadSheet.UI.ScrollBarTrackPolicy.Both      
    End Sub

    Private Sub Button_Click_1(sender As Object, e As RoutedEventArgs)
        'Uncomment a method to test
        'gcSpreadSheet1.Sheets(0).SetActiveCell(10, 7)
        'gcSpreadSheet1.ShowActiveCell(GrapeCity.Xaml.SpreadSheet.UI.VerticalPosition.Bottom, GrapeCity.Xaml.SpreadSheet.UI.HorizontalPosition.Left)
        'gcSpreadSheet1.ShowCell(0, 0, 20, 10, GrapeCity.Xaml.SpreadSheet.UI.VerticalPosition.Bottom, GrapeCity.Xaml.SpreadSheet.UI.HorizontalPosition.Right)
        'gcSpreadSheet1.ShowColumn(0, 10, GrapeCity.Xaml.SpreadSheet.UI.HorizontalPosition.Nearest)
        gcSpreadSheet1.ShowRow(0, 50, GrapeCity.Xaml.SpreadSheet.UI.VerticalPosition.Center)
    End Sub

Requirements

Target Platforms: Windows Server 2012, Windows RT

Reference

GcSpreadSheet Class
GcSpreadSheet Members