Spread Silverlight Documentation
ShowCell Method
Example 


The row viewport index.
The column viewport index.
The cell row index to show.
The cell column index to show.
The VerticalPosition to show.
The HorizontalPosition to show.
Moves a cell to the specified position.
Syntax
'Declaration
 
Public Sub ShowCell( _
   ByVal rowViewportIndex As System.Integer, _
   ByVal columnViewportIndex As System.Integer, _
   ByVal row As System.Integer, _
   ByVal column As System.Integer, _
   ByVal verticalPosition As VerticalPosition, _
   ByVal horizontalPosition As HorizontalPosition _
) 
'Usage
 
Dim instance As GcSpreadSheet
Dim rowViewportIndex As System.Integer
Dim columnViewportIndex As System.Integer
Dim row As System.Integer
Dim column As System.Integer
Dim verticalPosition As VerticalPosition
Dim horizontalPosition As HorizontalPosition
 
instance.ShowCell(rowViewportIndex, columnViewportIndex, row, column, verticalPosition, horizontalPosition)
public void ShowCell( 
   System.int rowViewportIndex,
   System.int columnViewportIndex,
   System.int row,
   System.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 VerticalPosition to show.
horizontalPosition
The HorizontalPosition to show.
Example
This example uses the ShowCell method.
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();           
        }
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
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

GcSpreadSheet Class
GcSpreadSheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.