Spread Windows Forms 11.0 Product Documentation
Changed Event (ISheetDataModel)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > ISheetDataModel Interface : Changed Event
Occurs when the data model has changed.
Syntax
'Declaration
 
Event Changed As SheetDataModelEventHandler
'Usage
 
Dim instance As ISheetDataModel
Dim handler As SheetDataModelEventHandler
 
AddHandler instance.Changed, handler
Event Data

The event handler receives an argument of type SheetDataModelEventArgs containing data related to this event. The following SheetDataModelEventArgs properties provide information specific to this event.

PropertyDescription
Gets the column index.  
Gets the number of columns.  
Gets the row index.  
Gets the number of rows.  
Gets the event type.  
Example
This example raises the changed event.
FarPoint.Win.Spread.Model.ISheetDataModel isdm;
isdm = (FarPoint.Win.Spread.Model.ISheetDataModel)fpSpread1.ActiveSheet.Models.Data;
isdm.Changed += new FarPoint.Win.Spread.Model.SheetDataModelEventHandler(this.isdm_Changed);
isdm.ColumnCount = 4;
isdm.RowCount = 5;

private void isdm_Changed(object sender, FarPoint.Win.Spread.Model.SheetDataModelEventArgs e)
{
     label1.Text = "The Model has Changed!!";
}
Friend WithEvents isdm As FarPoint.Win.Spread.Model.ISheetDataModel
isdm = FpSpread1.ActiveSheet.Models.Data
isdm.ColumnCount = 4
isdm.RowCount = 5

Private Sub isdm_Changed(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.Model.SheetDataModelEventArgs) Handles isdm.Changed
     Label1.Text = "The Model has Changed!!!"
End Sub
See Also