ShowCell Method

Moves a cell to the specified position.

Syntax

Visual Basic
C#

'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)

public void ShowCell( 
   int rowViewportIndex,
   int columnViewportIndex,
   int row,
   int column,
   VerticalPosition verticalPosition,
   HorizontalPosition 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.

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