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


In This Topic
    SheetSpanModelEventType Enumeration
    In This Topic
    Specifies the type of Change event that has occurred for a span model for the sheet.
    Syntax
    'Declaration
     
    Public Enum SheetSpanModelEventType 
       Inherits System.Enum
    'Usage
     
    Dim instance As SheetSpanModelEventType
    public enum SheetSpanModelEventType : System.Enum 
    Members
    MemberDescription
    ModelUpdated Indicates that the entire model has changed
    SpanAdded Indicates that an individual span has been added
    SpanRemoved Indicates that an individual span has been removed
    SpanUpdated Indicates that an individual span has changed
    Example
    This example causes the Changed event to occur for the SheetSpanModel and the type for the event is returned to a list box.
    FarPoint.Win.Spread.Model.DefaultSheetSpanModel spanModel = new FarPoint.Win.Spread.Model.DefaultSheetSpanModel();
    
    private void Form1_Load(object sender, System.EventArgs e)
    {
        fpSpread1.ActiveSheet.Models.Span = spanModel;
        this.spanModel.Changed += new FarPoint.Win.Spread.Model.SheetSpanModelEventHandler(this.spanModel_Changed);
    }
    
    private void menuItem1_Click(object sender, System.EventArgs e)
    {
        fpSpread1.ActiveSheet.Models.Span = spanModel;
        spanModel.Add(0, 0, 3, 3);
    }
    
    private void spanModel_Changed(object sender, FarPoint.Win.Spread.Model.SheetSpanModelEventArgs e)
    {
        switch (e.Type)
        {
            case FarPoint.Win.Spread.Model.SheetSpanModelEventType.SpanAdded:
                listBox1.Items.Add(e.Type.ToString());
                break;
            case FarPoint.Win.Spread.Model.SheetSpanModelEventType.SpanRemoved:
                listBox1.Items.Add(e.Type.ToString());
                break;
            case FarPoint.Win.Spread.Model.SheetSpanModelEventType.SpanUpdated:
                listBox1.Items.Add(e.Type.ToString());
                break;
            case FarPoint.Win.Spread.Model.SheetSpanModelEventType.ModelUpdated:
                listBox1.Items.Add(e.Type.ToString());
                break;
        }
    }
    Friend WithEvents spanModel As New FarPoint.Win.Spread.Model.DefaultSheetSpanModel()
    
    Private Sub MenuItem38_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem38.Click
    FpSpread1.ActiveSheet.Models.Span = spanModel
    spanModel.Add(0, 0, 3, 3)
    End Sub
    
    Private Sub spanModel_Changed(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.Model.SheetSpanModelEventArgs) Handles
    spanModel.Changed
    Select Case e.Type
        Case FarPoint.Win.Spread.Model.SheetSpanModelEventType.SpanAdded
            ListBox1.Items.Add(e.Type.ToString())
        Case FarPoint.Win.Spread.Model.SheetSpanModelEventType.SpanRemoved
            ListBox1.Items.Add(e.Type.ToString())
        Case FarPoint.Win.Spread.Model.SheetSpanModelEventType.SpanUpdated
            ListBox1.Items.Add(e.Type.ToString())
        Case FarPoint.Win.Spread.Model.SheetSpanModelEventType.ModelUpdated
            ListBox1.Items.Add(e.Type.ToString())
    End Select
    End Sub
    
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             FarPoint.Win.Spread.Model.SheetSpanModelEventType

    See Also