Gets the column index where the event occurred, or -1 if all columns were affected.
Syntax
Visual Basic (Declaration) | |
---|
Public ReadOnly Property Column As Integer |
C# | |
---|
public int Column {get;} |
Property Value
Integer index of the column where the event occurred
Example
This example returns the column index where the event occurred, in this case a -1 since all the columns were affected.
C# | Copy Code |
---|
FarPoint.Win.Spread.Model.BaseSheetStyleModel model;
model = (FarPoint.Win.Spread.Model.BaseSheetStyleModel)fpSpread1.ActiveSheet.Models.Style;
model.Changed += new FarPoint.Win.Spread.Model.SheetStyleModelEventHandler(model_StyleModelChanged);
private void button1_Click(object sender, System.EventArgs e)
{
FarPoint.Win.Spread.StyleInfo sInfo = new FarPoint.Win.Spread.StyleInfo();
sInfo.BackColor = Color.Teal;
model.AltRowCount = 2;
model.SetDirectAltRowInfo(0, sInfo);
}
private void model_StyleModelChanged(object sender, FarPoint.Win.Spread.Model.SheetStyleModelEventArgs e)
{
textBox1.Text = e.Column.ToString();
}
|
Visual Basic | Copy Code |
---|
Friend WithEvents model As FarPoint.Win.Spread.Model.BaseSheetStyleModel
model = FpSpread1.ActiveSheet.Models.Style
Dim h As FarPoint.Win.Spread.Model.SheetStyleModelEventHandler = AddressOf model_StyleModelChanged
AddHandler model.Changed, h
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim sInfo As New FarPoint.Win.Spread.StyleInfo
sInfo.BackColor = Color.Teal
model.AltRowCount = 2
model.SetDirectAltRowInfo(0, sInfo)
End Sub
Private Sub model_StyleModelChanged(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.Model.SheetStyleModelEventArgs)
TextBox1.Text = e.Column.ToString()
End Sub
|
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also