Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / CellClickEventArgs Class / Column Property
Example


In This Topic
    Column Property (CellClickEventArgs)
    In This Topic
    Gets the column index of the cell that is clicked.
    Syntax
    'Declaration
     
    Public ReadOnly Property Column As Integer
    'Usage
     
    Dim instance As CellClickEventArgs
    Dim value As Integer
     
    value = instance.Column
    public int Column {get;}

    Property Value

    Integer index of the column of the cell clicked
    Example
    This example uses the Column property.
    private void fpSpread1_CellClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
    {
        if(e.Button == MouseButtons.Left && e.ColumnHeader == false && e.RowHeader == false)
        {
            fpSpread1.ActiveSheet.Cells[e.Row, e.Column].BackColor = Color.Yellow;
        }
        else if (e.Button == MouseButtons.Right)
        {
            e.Cancel = true;
        }
    }
    
    Private Sub FpSpread1_CellClick(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.CellClickEventArgs) Handles FpSpread1.CellClick
        If e.Button = MouseButtons.Left And e.ColumnHeader = False And e.RowHeader = False Then
            FpSpread1.ActiveSheet.Cells(e.Row, e.Column).BackColor = Color.Yellow
        ElseIf e.Button = MouseButtons.Right Then
            e.Cancel = True
        End If
    End Sub
    
    Requirements

    Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

    See Also