Spread Windows Forms 9.0 Product Documentation
Column Property (SheetDataModelEventArgs)
Example 


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
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

Reference

SheetDataModelEventArgs Class
SheetDataModelEventArgs Members

 

 


Copyright © GrapeCity, inc. All rights reserved.