Spread WPF 14
GrapeCity.Windows.SpreadSheet.Data Namespace / Worksheet Class / ActiveRowIndex Property
Example


In This Topic
    ActiveRowIndex Property (Worksheet)
    In This Topic
    Gets or sets the row index of the active cell in the sheet.
    Syntax
    'Declaration
     
    Public Property ActiveRowIndex As Integer
    'Usage
     
    Dim instance As Worksheet
    Dim value As Integer
     
    instance.ActiveRowIndex = value
     
    value = instance.ActiveRowIndex
    public 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