Using Scroll Bars

You can set the scroll bar appearance, height, width, and visibility.

You can hide or show the vertical or horizontal scroll bar. You can also set the width of the vertical scroll bar and the height of the horizontal scroll bar.

You can use the thumb bar (drag button) to scroll large areas of the control. Use the button with the arrow to scroll a row or column at a time. You can also specify whether to scroll after releasing the mouse with the ScrollBarTrackPolicy property.

The control scrolls by default when selecting and dragging headers or cells outside of the current visible area.

Using Code

The following example sets properties for the scroll bar.

CS	Copy Code
private void Window_Loaded(object sender, RoutedEventArgs e) { var style = new System.Windows.Style(); gcSpreadSheet1.HorizontalScrollBarStyle = style; gcSpreadSheet1.VerticalScrollBarStyle = style; gcSpreadSheet1.HorizontalScrollBarVisibility = System.Windows.Controls.ScrollBarVisibility.Visible; gcSpreadSheet1.VerticalScrollBarVisibility = System.Windows.Controls.ScrollBarVisibility.Visible; gcSpreadSheet1.HorizontalScrollBarHeight = 20; gcSpreadSheet1.VerticalScrollBarWidth = 20; gcSpreadSheet1.ScrollBarTrackPolicy = GrapeCity.Windows.SpreadSheet.UI.ScrollBarTrackPolicy.Both; gcSpreadSheet1.Invalidate(); } private void button1_Click(object sender, RoutedEventArgs e) { //Uncomment a method to test //gcSpreadSheet1.Sheets[0].SetActiveCell(10, 7); //gcSpreadSheet1.ShowActiveCell(GrapeCity.Windows.SpreadSheet.UI.VerticalPosition.Bottom, GrapeCity.Windows.SpreadSheet.UI.HorizontalPosition.Left); //gcSpreadSheet1.ShowCell(0, 0, 20, 10, GrapeCity.Windows.SpreadSheet.UI.VerticalPosition.Bottom, GrapeCity.Windows.SpreadSheet.UI.HorizontalPosition.Right); //gcSpreadSheet1.ShowColumn(0, 10, GrapeCity.Windows.SpreadSheet.UI.HorizontalPosition.Nearest); gcSpreadSheet1.ShowRow(0, 50, GrapeCity.Windows.SpreadSheet.UI.VerticalPosition.Center); gcSpreadSheet1.Invalidate(); }

Copy Code

private void Window_Loaded(object sender, RoutedEventArgs e)
        {
var style = new System.Windows.Style();
gcSpreadSheet1.HorizontalScrollBarStyle = style;
gcSpreadSheet1.VerticalScrollBarStyle = style;
gcSpreadSheet1.HorizontalScrollBarVisibility = System.Windows.Controls.ScrollBarVisibility.Visible;
gcSpreadSheet1.VerticalScrollBarVisibility = System.Windows.Controls.ScrollBarVisibility.Visible;
gcSpreadSheet1.HorizontalScrollBarHeight = 20;
gcSpreadSheet1.VerticalScrollBarWidth = 20;
gcSpreadSheet1.ScrollBarTrackPolicy = GrapeCity.Windows.SpreadSheet.UI.ScrollBarTrackPolicy.Both;
gcSpreadSheet1.Invalidate();           
        }
private void button1_Click(object sender, RoutedEventArgs e)
        {
//Uncomment a method to test
//gcSpreadSheet1.Sheets[0].SetActiveCell(10, 7);
//gcSpreadSheet1.ShowActiveCell(GrapeCity.Windows.SpreadSheet.UI.VerticalPosition.Bottom, GrapeCity.Windows.SpreadSheet.UI.HorizontalPosition.Left);
//gcSpreadSheet1.ShowCell(0, 0, 20, 10, GrapeCity.Windows.SpreadSheet.UI.VerticalPosition.Bottom, GrapeCity.Windows.SpreadSheet.UI.HorizontalPosition.Right);
//gcSpreadSheet1.ShowColumn(0, 10, GrapeCity.Windows.SpreadSheet.UI.HorizontalPosition.Nearest);
gcSpreadSheet1.ShowRow(0, 50, GrapeCity.Windows.SpreadSheet.UI.VerticalPosition.Center);
gcSpreadSheet1.Invalidate();          
        }

VB.NET	Copy Code
Private Sub Window_Loaded(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles MyBase.Loaded Dim style As New System.Windows.Style() GcSpreadSheet1.HorizontalScrollBarStyle = style GcSpreadSheet1.VerticalScrollBarStyle = style GcSpreadSheet1.HorizontalScrollBarVisibility = System.Windows.Controls.ScrollBarVisibility.Visible GcSpreadSheet1.VerticalScrollBarVisibility = System.Windows.Controls.ScrollBarVisibility.Visible GcSpreadSheet1.HorizontalScrollBarHeight = 20 GcSpreadSheet1.VerticalScrollBarWidth = 20 GcSpreadSheet1.ScrollBarTrackPolicy = GrapeCity.Windows.SpreadSheet.UI.ScrollBarTrackPolicy.Both GcSpreadSheet1.Invalidate() End Sub Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click 'Uncomment a method to test 'GcSpreadSheet1.Sheets(0).SetActiveCell(10, 7) 'GcSpreadSheet1.ShowActiveCell(GrapeCity.Windows.SpreadSheet.UI.VerticalPosition.Bottom, GrapeCity.Windows.SpreadSheet.UI.HorizontalPosition.Left) 'GcSpreadSheet1.ShowCell(0, 0, 20, 10, GrapeCity.Windows.SpreadSheet.UI.VerticalPosition.Bottom, GrapeCity.Windows.SpreadSheet.UI.HorizontalPosition.Right) 'GcSpreadSheet1.ShowColumn(0, 10, GrapeCity.Windows.SpreadSheet.UI.HorizontalPosition.Nearest) GcSpreadSheet1.ShowRow(0, 50, GrapeCity.Windows.SpreadSheet.UI.VerticalPosition.Center) GcSpreadSheet1.Invalidate() End Sub

VB.NET

Copy Code

Private Sub Window_Loaded(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles MyBase.Loaded
         Dim style As New System.Windows.Style()
        GcSpreadSheet1.HorizontalScrollBarStyle = style
        GcSpreadSheet1.VerticalScrollBarStyle = style
        GcSpreadSheet1.HorizontalScrollBarVisibility = System.Windows.Controls.ScrollBarVisibility.Visible
        GcSpreadSheet1.VerticalScrollBarVisibility = System.Windows.Controls.ScrollBarVisibility.Visible
        GcSpreadSheet1.HorizontalScrollBarHeight = 20
        GcSpreadSheet1.VerticalScrollBarWidth = 20
        GcSpreadSheet1.ScrollBarTrackPolicy = GrapeCity.Windows.SpreadSheet.UI.ScrollBarTrackPolicy.Both
        GcSpreadSheet1.Invalidate()
End Sub
Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
        'Uncomment a method to test
        'GcSpreadSheet1.Sheets(0).SetActiveCell(10, 7)
        'GcSpreadSheet1.ShowActiveCell(GrapeCity.Windows.SpreadSheet.UI.VerticalPosition.Bottom, GrapeCity.Windows.SpreadSheet.UI.HorizontalPosition.Left)
        'GcSpreadSheet1.ShowCell(0, 0, 20, 10, GrapeCity.Windows.SpreadSheet.UI.VerticalPosition.Bottom, GrapeCity.Windows.SpreadSheet.UI.HorizontalPosition.Right)
        'GcSpreadSheet1.ShowColumn(0, 10, GrapeCity.Windows.SpreadSheet.UI.HorizontalPosition.Nearest)
        GcSpreadSheet1.ShowRow(0, 50, GrapeCity.Windows.SpreadSheet.UI.VerticalPosition.Center)
        GcSpreadSheet1.Invalidate()
End Sub