SheetDataModelEventHandler Delegate

Visual Basic
C#

'Declaration
 
Public Delegate Sub SheetDataModelEventHandler( _
   ByVal sender As Object, _
   ByVal e As SheetDataModelEventArgs _
)

'Usage
 
Dim instance As New SheetDataModelEventHandler(AddressOf HandlerMethod)

public delegate void SheetDataModelEventHandler( 
   object sender,
   SheetDataModelEventArgs e
)

Parameters

sender
e

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

This example creates the handler for the model.

C#

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 Basic

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

Reference

SheetDataModelEventHandler Members
FarPoint.Win.Spread.Model Namespace
SheetDataModelEventArgs Class
Changed Event