Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.Model Namespace / DefaultSheetAxisModel Class / SetSortIndicator Method
Row or column index
Value with the SortIndicator enumeration
Example


In This Topic
    SetSortIndicator Method (DefaultSheetAxisModel)
    In This Topic
    Sets the sort indicator for the specified row or column.
    Syntax
    'Declaration
     
    Public Overrides Sub SetSortIndicator( _
       ByVal index As Integer, _
       ByVal value As SortIndicator _
    ) 
    'Usage
     
    Dim instance As DefaultSheetAxisModel
    Dim index As Integer
    Dim value As SortIndicator
     
    instance.SetSortIndicator(index, value)
    public override void SetSortIndicator( 
       int index,
       SortIndicator value
    )

    Parameters

    index
    Row or column index
    value
    Value with the SortIndicator enumeration
    Example
    This example sets and returns the sort indicator for the specified column.
    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