Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Enum SheetDataModelEventType Inherits System.Enum | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As SheetDataModelEventType | |
| C# | |
|---|---|
public enum SheetDataModelEventType : System.Enum | |
Members
| Member | Description |
|---|---|
| AggregationUpdate | Indicates that the aggregation data model has been updated |
| CellsUpdated | Indicates that cells with cell data have been updated |
| ColumnsAdded | Indicates that columns have been added |
| ColumnsRemoved | Indicates that columns have been removed |
| ModelUpdated | Indicates that the sheet data model has been updated |
| RowsAdded | Indicates that rows have been added |
| RowsRemoved | Indicates that rows have been removed |
Example
This example causes the Changed event to occur for the SheetDataModel and the type for the event is returned to a list box.
| C# | Copy Code |
|---|---|
FarPoint.Win.Spread.Model.DefaultSheetDataModel defModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5); private void Form1_Load(object sender, System.EventArgs e) { fpSpread1.ActiveSheet.Models.Data = defModel; this.defModel.Changed += new FarPoint.Win.Spread.Model.SheetDataModelEventHandler(this.defModel_Changed); } private void menuItem1_Click(object sender, System.EventArgs e) { fpSpread1.ActiveSheet.Models.Data = defModel; defModel.SetValue(0, 0, "CellsUpdated"); } private void defModel_Changed(object sender, FarPoint.Win.Spread.Model.SheetDataModelEventArgs e) { switch (e.Type) { case FarPoint.Win.Spread.Model.SheetDataModelEventType.CellsUpdated: listBox1.Items.Add(e.Type.ToString()); break; case FarPoint.Win.Spread.Model.SheetDataModelEventType.RowsAdded: listBox1.Items.Add(e.Type.ToString()); break; case FarPoint.Win.Spread.Model.SheetDataModelEventType.RowsRemoved: listBox1.Items.Add(e.Type.ToString()); break; case FarPoint.Win.Spread.Model.SheetDataModelEventType.ColumnsAdded: listBox1.Items.Add(e.Type.ToString()); break; case FarPoint.Win.Spread.Model.SheetDataModelEventType.ColumnsRemoved: listBox1.Items.Add(e.Type.ToString()); break; case FarPoint.Win.Spread.Model.SheetDataModelEventType.ModelUpdated: listBox1.Items.Add(e.Type.ToString()); break; } } | |
| Visual Basic | Copy Code |
|---|---|
Friend WithEvents defModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5) Private Sub MenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem1.Click FpSpread1.ActiveSheet.Models.Data = defModel defModel.SetValue(0, 0, "CellsUpdated") End Sub Private Sub defModel_Changed(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.Model.SheetDataModelEventArgs) Handles defModel.Changed Select Case e.Type Case FarPoint.Win.Spread.Model.SheetDataModelEventType.CellsUpdated ListBox1.Items.Add(e.Type.ToString()) Case FarPoint.Win.Spread.Model.SheetDataModelEventType.RowsAdded ListBox1.Items.Add(e.Type.ToString()) Case FarPoint.Win.Spread.Model.SheetDataModelEventType.RowsRemoved ListBox1.Items.Add(e.Type.ToString()) Case FarPoint.Win.Spread.Model.SheetDataModelEventType.ColumnsAdded ListBox1.Items.Add(e.Type.ToString()) Case FarPoint.Win.Spread.Model.SheetDataModelEventType.ColumnsRemoved ListBox1.Items.Add(e.Type.ToString()) Case FarPoint.Win.Spread.Model.SheetDataModelEventType.ModelUpdated ListBox1.Items.Add(e.Type.ToString()) End Select End Sub | |
Inheritance Hierarchy
System.Object
System.ValueType
System.Enum
FarPoint.Win.Spread.Model.SheetDataModelEventType
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8