Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.Model Namespace / DefaultSheetAxisModel Class / GetSortIndicator Method
Row or column index
Example


In This Topic
    GetSortIndicator Method (DefaultSheetAxisModel)
    In This Topic
    Gets the sort indicator for the specified row or column.
    Syntax
    'Declaration
     
    Public Overrides Function GetSortIndicator( _
       ByVal index As Integer _
    ) As SortIndicator
    'Usage
     
    Dim instance As DefaultSheetAxisModel
    Dim index As Integer
    Dim value As SortIndicator
     
    value = instance.GetSortIndicator(index)
    public override SortIndicator GetSortIndicator( 
       int index
    )

    Parameters

    index
    Row or column index

    Return Value

    SortIndicator setting that determines how the sort indicator is displayed for the column
    Example
    FarPoint.Win.Spread.Model.DefaultSheetAxisModel dsam = new FarPoint.Win.Spread.Model.DefaultSheetAxisModel(3, FarPoint.Win.Spread.Model.SheetAxisOrientation.Horizontal);
    dsam = (FarPoint.Win.Spread.Model.DefaultSheetAxisModel)fpSpread1.ActiveSheet.Models.ColumnAxis;
    dsam.SetSortIndicator(0, FarPoint.Win.Spread.Model.SortIndicator.Ascending);
    fpSpread1.ActiveSheet.Columns[0].AllowAutoSort = true;
    fpSpread1.ActiveSheet.SetText(0, 0, "Uno");
    fpSpread1.ActiveSheet.SetText(1, 0, "Dos");
    fpSpread1.ActiveSheet.SetText(2, 0, "Tres");
    
    FarPoint.Win.Spread.Model.SortIndicator si;
    si = dsam.GetSortIndicator(0);
    MessageBox.Show("The sort indicator is " + si.ToString());
    
    Dim dsam As New FarPoint.Win.Spread.Model.DefaultSheetAxisModel(3, FarPoint.Win.Spread.Model.SheetAxisOrientation.Horizontal)
    dsam = fpSpread1.ActiveSheet.Models.ColumnAxis
    dsam.SetSortIndicator(0, FarPoint.Win.Spread.Model.SortIndicator.Ascending)
    fpSpread1.ActiveSheet.Columns(0).AllowAutoSort = True
    fpSpread1.ActiveSheet.SetText(0, 0, "Uno")
    fpSpread1.ActiveSheet.SetText(1, 0, "Dos")
    fpSpread1.ActiveSheet.SetText(2, 0, "Tres")
    
    Dim si As FarPoint.Win.Spread.Model.SortIndicator
    si = dsam.GetSortIndicator(0)
    MessageBox.Show("The sort indicator is " & si.ToString())
    See Also