Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.Model Namespace / SheetDataModelEventType Enumeration
Example Example


In This Topic
    SheetDataModelEventType Enumeration
    In This Topic
    Specifies the type of Change event that has occurred for an axis model for the sheet.
    Syntax
    'Declaration
     
    Public Enum SheetDataModelEventType 
       Inherits System.Enum
    'Usage
     
    Dim instance As SheetDataModelEventType
    public enum SheetDataModelEventType : System.Enum 
    Members
    MemberDescription
    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.
    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;
        }
    }
    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

    See Also