Spread Windows Forms 6.0 Product Documentation
SheetDataModelEventHandler Delegate
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace : SheetDataModelEventHandler Delegate


Glossary Item Box

Handles the Changed event in the data model of the sheet.


Visual Basic (Declaration) 
Public Delegate Sub SheetDataModelEventHandler( _
   ByVal sender As Object, _
   ByVal e As SheetDataModelEventArgs _
Visual Basic (Usage)Copy Code
Dim instance As New SheetDataModelEventHandler(AddressOf HandlerMethod)
public delegate void SheetDataModelEventHandler( 
   object sender,
   SheetDataModelEventArgs e




For information on the event, refer to the Changed event.


This example creates the handler for the model.
C#Copy Code
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(modelDataModelChanged); 
private void button1Click(object sender, System.EventArgs e) 
    model.SetValue(0, 2, "DataModel"); 
private void modelDataModelChanged(object sender, FarPoint.Win.Spread.Model.SheetDataModelEventArgs e) 
     textBox1.Text = e.Column.ToString(); 
Visual BasicCopy Code
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 modelDataModelChanged
AddHandler model.Changed, h

Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    model.SetValue(0, 2, "DataModel")
End Sub

Private Sub modelDataModelChanged(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.Model.SheetDataModelEventArgs)
    TextBox1.Text = e.Column.ToString()
End Sub


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

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.