Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.Model Namespace / SheetAxisModelEventArgs Class / Index Property
Example


In This Topic
    Index Property (SheetAxisModelEventArgs)
    In This Topic
    Gets the index where the event happens.
    Syntax
    'Declaration
     
    Public ReadOnly Property Index As Integer
    'Usage
     
    Dim instance As SheetAxisModelEventArgs
    Dim value As Integer
     
    value = instance.Index
    public int Index {get;}

    Property Value

    Integer row index or column index
    Example
    This example illustrates the use of this member by returning the column affected by the change. For example, resize one of the column headers, which will return the zero-based index of that column.
    FarPoint.Win.Spread.Model.BaseSheetAxisModel bsam;
    bsam = (FarPoint.Win.Spread.Model.BaseSheetAxisModel)fpSpread1.ActiveSheet.Models.ColumnAxis;
    bsam.SetSize(0, 120);
    
    bsam.Changed += new FarPoint.Win.Spread.Model.SheetAxisModelEventHandler(bsam_AxisModelChanged);
    
    
    private void bsam_AxisModelChanged(object sender, FarPoint.Win.Spread.Model.SheetAxisModelEventArgs e)
    {
        textBox1.Text = e.Index.ToString();
    }
    
    Dim bsam As FarPoint.Win.Spread.Model.BaseSheetAxisModel
    bsam = FpSpread1.ActiveSheet.Models.ColumnAxis
    bsam.SetSize(0, 120)
    
    Dim h As FarPoint.Win.Spread.Model.SheetAxisModelEventHandler = AddressOf bsam_AxisModelChanged
    AddHandler bsam.Changed, h
    
    Private Sub bsam_AxisModelChanged(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.Model.SheetAxisModelEventArgs)
        TextBox1.Text = e.Index.ToString()
    End Sub
    
    See Also