Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SortInfo Class / Index Property
Example


In This Topic
    Index Property (SortInfo)
    In This Topic
    Gets or sets the index of the column or row on which to sort.
    Syntax
    'Declaration
     
    Public Property Index As Integer
    'Usage
     
    Dim instance As SortInfo
    Dim value As Integer
     
    instance.Index = value
     
    value = instance.Index
    public int Index {get; set;}

    Property Value

    Integer index of the row or column
    Example
    This example sorts the columns using the sort array.
    FarPoint.Web.Spread.SortInfo si0 = new FarPoint.Web.Spread.SortInfo(0, true, System.Collections.Comparer.Default);
    FarPoint.Web.Spread.SortInfo si1 = new FarPoint.Web.Spread.SortInfo(1, true); FarPoint.Web.Spread.SortInfo si2 = new FarPoint.Web.Spread.SortInfo(2,
    true);
    
    si1.Ascending = false;
    si1.Index = 1;
    si1.Comparer = System.Collections.Comparer.Default;
    
    FpSpread1.ActiveSheetView.SetValue(0, 0, "D"); FpSpread1.ActiveSheetView.SetValue(1, 0, "F"); FpSpread1.ActiveSheetView.SetValue(2,
    0, "E");
    
    FpSpread1.ActiveSheetView.SetValue(0, 1, "A"); FpSpread1.ActiveSheetView.SetValue(1, 1, "C"); FpSpread1.ActiveSheetView.SetValue(2,
    1, "B");
    
    FpSpread1.ActiveSheetView.SetValue(0, 2, "G"); FpSpread1.ActiveSheetView.SetValue(1, 2, "I"); FpSpread1.ActiveSheetView.SetValue(2,
    2, "H");
    
    FarPoint.Web.Spread.SortInfo[] si = new FarPoint.Web.Spread.SortInfo[] {si0, si1, si2}; FpSpread1.ActiveSheetView.SortColumns(0,
    3, si); 
     
    
    Dim si0 As New FarPoint.Web.Spread.SortInfo(0, True,
    System.Collections.Comparer.Default)
    Dim si1 As New FarPoint.Web.Spread.SortInfo(1, True)
    Dim si2 As New FarPoint.Web.Spread.SortInfo(2, True)
    
    si1.Ascending = False
    si1.Index = 1
    si1.Comparer = System.Collections.Comparer.Default
    
    FpSpread1.ActiveSheetView.SetValue(0, 0, "D") FpSpread1.ActiveSheetView.SetValue(1, 0, "F") FpSpread1.ActiveSheetView.SetValue(2,
    0, "E")
    
    FpSpread1.ActiveSheetView.SetValue(0, 1, "A") FpSpread1.ActiveSheetView.SetValue(1, 1, "C") FpSpread1.ActiveSheetView.SetValue(2,
    1, "B")
    
    FpSpread1.ActiveSheetView.SetValue(0, 2, "G") FpSpread1.ActiveSheetView.SetValue(1, 2, "I") FpSpread1.ActiveSheetView.SetValue(2,
    2, "H")
    
    Dim si() As FarPoint.Web.Spread.SortInfo = New
    FarPoint.Web.Spread.SortInfo() {si0, si1, si2} FpSpread1.ActiveSheetView.SortColumns(0, 3, si) 
    See Also