Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Column Class / SortIndicator Property
Example


In This Topic
    SortIndicator Property
    In This Topic
    Gets or sets the sort indicator for this column.
    Syntax
    'Declaration
     
    Public Property SortIndicator As SortIndicator
    'Usage
     
    Dim instance As Column
    Dim value As SortIndicator
     
    instance.SortIndicator = value
     
    value = instance.SortIndicator
    public SortIndicator SortIndicator {get; set;}

    Property Value

    SortIndicator setting
    Remarks

    The sort indicator appears after the data is sorted and appears only in the column by which the data is sorted.

    Example
    This example creates a Column object for the default active spreadsheet, sets text in the first three rows of the column and in a button click event sorts the data in the column. The sort indicator for the column is displayed after the column is sorted.
    private void Page_Load(object sender,System.EventArgs e)
    {
    if(this.IsPostBack)return;
    
    FarPoint.Web.Spread.Column mycol;
    mycol = FpSpread1.ActiveSheetView.Columns[1];
    FpSpread1.ActiveSheetView.SetValue(0,1,"Alignment");
    FpSpread1.ActiveSheetView.SetValue(1,1,"CarbAdjust");
    FpSpread1.ActiveSheetView.SetValue(2,1,"Brakes");
    mycol.SortIndicator = FarPoint.Web.Spread.Model.SortIndicator.Descending;
    FpSpread1.Sheets[0].AllowSort = true;
    }
    
    private void Button1_Click(object sender,System.EventArgs e)
    {
    FpSpread1.ActiveSheetView.SortRows(1, true, true);
    }
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
            If (Me.IsPostBack) Then Return
            Dim mycol As FarPoint.Web.Spread.Column
            mycol = FpSpread1.ActiveSheetView.Columns(1)
            FpSpread1.ActiveSheetView.SetValue(0, 1, "Alignment")
            FpSpread1.ActiveSheetView.SetValue(1, 1, "CarbAdjust")
            FpSpread1.ActiveSheetView.SetValue(2, 1, "Brakes")
            mycol.SortIndicator = FarPoint.Web.Spread.Model.SortIndicator.Descending        
            FpSpread1.Sheets(0).AllowSort = True
        End Sub
    
    Private Sub Button1_Click(ByVal sender As System.Object,ByVal e As System.EventArgs) Handles Button1.Click
    FpSpread1.ActiveSheetView.SortRows(1, True, True)
    End Sub
    See Also