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


In This Topic
    ActiveRow Property
    In This Topic
    Gets the active row in the sheet.
    Syntax
    'Declaration
     
    Public ReadOnly Property ActiveRow As Row
    'Usage
     
    Dim instance As Worksheet
    Dim value As Row
     
    value = instance.ActiveRow
    public Row ActiveRow {get;}

    Property Value

    The active row in the sheet.
    Example
    This example gets the ActiveRow 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