Spread Silverlight Documentation
ActiveColumn Property
Example 


Gets the active column in the sheet.
Syntax
'Declaration
 
Public ReadOnly Property ActiveColumn As Column
'Usage
 
Dim instance As Worksheet
Dim value As Column
 
value = instance.ActiveColumn
public Column ActiveColumn {get;}

Property Value

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

Worksheet Class
Worksheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.