Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.Model Namespace / BaseSheetAxisModel Class / Changed Event
Example


In This Topic
    Changed Event (BaseSheetAxisModel)
    In This Topic
    Occurs when the user makes a change to the model that affects the axis (row or column) of the sheet.
    Syntax
    'Declaration
     
    Public Event Changed As SheetAxisModelEventHandler
    'Usage
     
    Dim instance As BaseSheetAxisModel
    Dim handler As SheetAxisModelEventHandler
     
    AddHandler instance.Changed, handler
    public event SheetAxisModelEventHandler Changed
    Event Data

    The event handler receives an argument of type SheetAxisModelEventArgs containing data related to this event. The following SheetAxisModelEventArgs properties provide information specific to this event.

    PropertyDescription
    Gets the number of items being affected.  
    Gets the index where the event happens.  
    Gets the event type.  
    Remarks
    When a class is derived from this abstract class, this event occurs after the user makes a change to the model that affects the axis (row or column) of the sheet.
    Example
    This example causes the Changed event to occur for the model.
    private void button1_Click(object sender, System.EventArgs e)
    {
    FarPoint.Win.Spread.Model.BaseSheetAxisModel model;
    model = (FarPoint.Win.Spread.Model.BaseSheetAxisModel)fpSpread1.ActiveSheet.Models.ColumnAxis; 
    model.SetSize(0, 120); 
    }
    
    private void fpSpread1_AxisModelChanged(object sender, FarPoint.Win.Spread.Model.SheetAxisModelEventArgs e) 
    { 
    fpSpread1.ActiveSheet.SetValue(0,0,"Fired"); 
    } 
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim modelAs FarPoint.Win.Spread.Model.BaseSheetAxisModel
    model = fpSpread1.ActiveSheet.Models.ColumnAxis
    model.SetSize(0, 120)
    End Sub
    
    Private Sub fpSpread1_AxisModelChanged(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.Model.SheetAxisModelEventArgs)
    Handles model.Changed
    fpSpread1.ActiveSheet.SetValue(2, 0, "Fired")
    End Sub
    End Class
    See Also