SheetSpanModelEventType Enumeration

Specifies the type of Change event that has occurred for a span model for the sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum SheetSpanModelEventType 
   Inherits System.Enum

'Usage
 
Dim instance As SheetSpanModelEventType

public enum SheetSpanModelEventType : System.Enum

Members

Member	Description
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;
    }
}

Visual Basic

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

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

FarPoint.Win.Spread.Model Namespace