Spread WPF Documentation
ActiveRowIndex Property (Worksheet)
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > Worksheet Class : ActiveRowIndex Property
Gets or sets the row index of the active cell in the sheet.
Syntax
'Declaration
 
Public Property ActiveRowIndex As System.Integer
'Usage
 
Dim instance As Worksheet
Dim value As System.Integer
 
instance.ActiveRowIndex = value
 
value = instance.ActiveRowIndex
public System.int ActiveRowIndex {get; set;}

Property Value

The row index of the active cell in the sheet.
Example
This example gets the ActiveRowIndex property.
gcSpreadSheet1.Sheets[0].SetActiveCell(5, 5);
//gcSpreadSheet1.Sheets[0].SetActiveCell(2, 2, true);
gcSpreadSheet1.Invalidate();

private void button1_Click(object sender, RoutedEventArgs e)
        {
        listBox1.Items.Add(GcSpreadSheet1.Sheets[0].ActiveCell().ToString());
        listBox1.Items.Add(GcSpreadSheet1.Sheets[0].ActiveColumn.ToString());
        listBox1.Items.Add(GcSpreadSheet1.Sheets[0].ActiveColumnIndex);
        listBox1.Items.Add(GcSpreadSheet1.Sheets[0].ActiveRow.ToString());
        listBox1.Items.Add(GcSpreadSheet1.Sheets[0].ActiveRowIndex);
        gcSpreadSheet1.Invalidate();
         }

private void gcSpreadSheet1_EnterCell(object sender, GrapeCity.Windows.SpreadSheet.UI.EnterCellEventArgs e)
        {
        listBox1.Items.Add(e.Column.ToString());
        listBox1.Items.Add(e.Row.ToString());
        }

private void gcSpreadSheet1_LeaveCell(object sender, GrapeCity.Windows.SpreadSheet.UI.LeaveCellEventArgs e)
    {
       listBox1.Items.Add(e.Column.ToString());
       listBox1.Items.Add(e.Row.ToString());
   }
GcSpreadSheet1.Sheets(0).SetActiveCell(5, 5)
'GcSpreadSheet1.Sheets(0).SetActiveCell(2, 2, True)
GcSpreadSheet1.Invalidate()

Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
        ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).ActiveCell().ToString())
        ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).ActiveColumn.ToString())
        ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).ActiveColumnIndex)
        ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).ActiveRow.ToString())
        ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).ActiveRowIndex)
        GcSpreadSheet1.Invalidate()
    End Sub

Private Sub GcSpreadSheet1_EnterCell(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.EnterCellEventArgs) Handles GcSpreadSheet1.EnterCell
        ListBox1.Items.Add(e.Column.ToString())
        ListBox1.Items.Add(e.Row.ToString())
    End Sub

    Private Sub GcSpreadSheet1_LeaveCell(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.LeaveCellEventArgs) Handles GcSpreadSheet1.LeaveCell
        ListBox1.Items.Add(e.Column.ToString())
        ListBox1.Items.Add(e.Row.ToString())
    End Sub
See Also

Reference

Worksheet Class
Worksheet Members