Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Enum SheetStyleModelEventType Inherits System.Enum | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As SheetStyleModelEventType | |
| C# | |
|---|---|
public enum SheetStyleModelEventType : System.Enum | |
Members
| Member | Description |
|---|---|
| CellsUpdated | Indicates that the style of one or more cells has changed |
| ColumnsAdded | Indicates that the style of one or more columns have been added |
| ColumnsRemoved | Indicates that the style of one or more columns have been removed |
| ModelUpdated | Indicates that the model has been updated such that all styles may have changed |
| RowsAdded | Indicates that the style of one or more rows have been added |
| RowsRemoved | Indicates that the style of one or more rows have been removed |
Example
This example causes the Changed event to occur for the SheetStyleModel and the type for the event is returned to a list box.
| C# | Copy Code |
|---|---|
FarPoint.Win.Spread.Model.DefaultSheetStyleModel styleModel = new FarPoint.Win.Spread.Model.DefaultSheetStyleModel(); private void Form1_Load(object sender, System.EventArgs e) { styleModel = (FarPoint.Win.Spread.Model.DefaultSheetStyleModel)fpSpread1.ActiveSheet.Models.Style; this.styleModel.Changed += new FarPoint.Win.Spread.Model.SheetStyleModelEventHandler(this.styleModel_Changed); } private void menuItem1_Click(object sender, System.EventArgs e) { styleModel = (FarPoint.Win.Spread.Model.DefaultSheetStyleModel)fpSpread1.ActiveSheet.Models.Style; styleModel.AltRowCount = 3; } private void styleModel_Changed(object sender, FarPoint.Win.Spread.Model.SheetStyleModelEventArgs e) { switch (e.Type) { case FarPoint.Win.Spread.Model.SheetStyleModelEventType.CellsUpdated: listBox1.Items.Add(e.Type.ToString()); break; case FarPoint.Win.Spread.Model.SheetStyleModelEventType.RowsAdded: listBox1.Items.Add(e.Type.ToString()); break; case FarPoint.Win.Spread.Model.SheetStyleModelEventType.RowsRemoved: listBox1.Items.Add(e.Type.ToString()); break; case FarPoint.Win.Spread.Model.SheetStyleModelEventType.ColumnsAdded: listBox1.Items.Add(e.Type.ToString()); break; case FarPoint.Win.Spread.Model.SheetStyleModelEventType.ColumnsRemoved: listBox1.Items.Add(e.Type.ToString()); break; case FarPoint.Win.Spread.Model.SheetStyleModelEventType.ModelUpdated: listBox1.Items.Add(e.Type.ToString()); break; } } | |
| Visual Basic | Copy Code |
|---|---|
Friend WithEvents styleModel As New FarPoint.Win.Spread.Model.DefaultSheetStyleModel() Private Sub MenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem1.Click styleModel = FpSpread1.ActiveSheet.Models.Style styleModel.AltRowCount = 3 End Sub Private Sub styleModel_Changed(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.Model.SheetStyleModelEventArgs) Handles styleModel.Changed Select Case e.Type Case FarPoint.Win.Spread.Model.SheetStyleModelEventType.CellsUpdated ListBox1.Items.Add(e.Type.ToString()) Case FarPoint.Win.Spread.Model.SheetStyleModelEventType.RowsAdded ListBox1.Items.Add(e.Type.ToString()) Case FarPoint.Win.Spread.Model.SheetStyleModelEventType.RowsRemoved ListBox1.Items.Add(e.Type.ToString()) Case FarPoint.Win.Spread.Model.SheetStyleModelEventType.ColumnsAdded ListBox1.Items.Add(e.Type.ToString()) Case FarPoint.Win.Spread.Model.SheetStyleModelEventType.ColumnsRemoved ListBox1.Items.Add(e.Type.ToString()) Case FarPoint.Win.Spread.Model.SheetStyleModelEventType.ModelUpdated ListBox1.Items.Add(e.Type.ToString()) End Select End Sub | |
Inheritance Hierarchy
System.Object
System.ValueType
System.Enum
FarPoint.Win.Spread.Model.SheetStyleModelEventType
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