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


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

    Property Value

    Integer index of the column where the event occurred
    Example
    FarPoint.Win.Spread.Model.BaseSheetDataModel model;
    
    model = (FarPoint.Win.Spread.Model.BaseSheetDataModel)fpSpread1.ActiveSheet.Models.Data;
    model.ColumnCount = 4;
    
    model.Changed += new FarPoint.Win.Spread.Model.SheetDataModelEventHandler(model_DataModelChanged);
        
    private void button1_Click(object sender, System.EventArgs e)
    {
        model.SetValue(0, 2, "DataModel");
    }
    
    private void model_DataModelChanged(object sender, FarPoint.Win.Spread.Model.SheetDataModelEventArgs e)
    {
         textBox1.Text = e.Column.ToString();
    }
    
    Friend WithEvents model As FarPoint.Win.Spread.Model.BaseSheetDataModel
    
    model = FpSpread1.ActiveSheet.Models.Data
    model.ColumnCount = 4
    
    Dim h As FarPoint.Win.Spread.Model.SheetDataModelEventHandler = AddressOf model_DataModelChanged
    AddHandler model.Changed, h
    
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        model.SetValue(0, 2, "DataModel")
    End Sub
    
    Private Sub model_DataModelChanged(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.Model.SheetDataModelEventArgs)
        TextBox1.Text = e.Column.ToString()
    End Sub
    
    See Also