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


In This Topic
    ActiveColumnIndex Property (Worksheet)
    In This Topic
    Gets or sets the column index of the active cell in the sheet.
    Syntax
    'Declaration
     
    Public Property ActiveColumnIndex As Integer
    'Usage
     
    Dim instance As Worksheet
    Dim value As Integer
     
    instance.ActiveColumnIndex = value
     
    value = instance.ActiveColumnIndex
    public int ActiveColumnIndex {get; set;}

    Property Value

    The column index of the active cell in the sheet.
    Example
    This example gets the ActiveColumnIndex 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