GrapeCity.Xaml.SpreadSheet.UI
ShowCell Method
Example 


GrapeCity.Xaml.SpreadSheet.UI Namespace > GcSpreadSheet Class : ShowCell Method
The row viewport index.
The column viewport index.
The cell row index to show.
The cell column index to show.
The GrapeCity.Windows.SpreadSheet.UI.VerticalPosition to show.
The GrapeCity.Windows.SpreadSheet.UI.HorizontalPosition to show.
Moves a cell to the specified position.
Syntax
'Declaration
 
Public Sub ShowCell( _
   ByVal rowViewportIndex As Integer, _
   ByVal columnViewportIndex As Integer, _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal verticalPosition As VerticalPosition, _
   ByVal horizontalPosition As HorizontalPosition _
) 
'Usage
 
Dim instance As GcSpreadSheet
Dim rowViewportIndex As Integer
Dim columnViewportIndex As Integer
Dim row As Integer
Dim column As Integer
Dim verticalPosition As VerticalPosition
Dim horizontalPosition As HorizontalPosition
 
instance.ShowCell(rowViewportIndex, columnViewportIndex, row, column, verticalPosition, horizontalPosition)

Parameters

rowViewportIndex
The row viewport index.
columnViewportIndex
The column viewport index.
row
The cell row index to show.
column
The cell column index to show.
verticalPosition
The GrapeCity.Windows.SpreadSheet.UI.VerticalPosition to show.
horizontalPosition
The GrapeCity.Windows.SpreadSheet.UI.HorizontalPosition to show.
Example
This example uses the ShowCell method.
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
See Also

Reference

GcSpreadSheet Class
GcSpreadSheet Members