GrapeCity.Xaml.SpreadSheet.UI
Column Property (LeaveCellEventArgs)
Example 


Gets the column index of the cell being left.
Syntax
'Declaration
 
Public ReadOnly Property Column As Integer
'Usage
 
Dim instance As LeaveCellEventArgs
Dim value As Integer
 
value = instance.Column
public int Column {get;}

Property Value

The column index of the cell being left.
Example
This example uses the LeaveCell event.
gcSpreadSheet1.Sheets[0].SetActiveCell(5, 5);

private void Button_Click_1(object sender, RoutedEventArgs e)
        {

            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);                      
        }

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

        private void gcSpreadSheet1_LeaveCell(object sender, GrapeCity.Xaml.SpreadSheet.UI.LeaveCellEventArgs e)
        {
            listBox1.Items.Add(e.Column.ToString());
            listBox1.Items.Add(e.Row.ToString());
        }
gcSpreadSheet1.Sheets(0).SetActiveCell(5, 5)

Private Sub Button_Click_1(sender As Object, e As RoutedEventArgs)        
        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)
    End Sub

    Private Sub gcSpreadSheet1_EnterCell(sender As Object, e As GrapeCity.Xaml.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 Object, e As GrapeCity.Xaml.SpreadSheet.UI.LeaveCellEventArgs) Handles gcSpreadSheet1.LeaveCell
        ListBox1.Items.Add(e.Column.ToString())
        ListBox1.Items.Add(e.Row.ToString())
    End Sub
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

LeaveCellEventArgs Class
LeaveCellEventArgs Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options