Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / GetColumnSortIndicator Method
Column index
Example


In This Topic
    GetColumnSortIndicator Method
    In This Topic
    Gets the sort indicator to display at the specified column.
    Syntax
    'Declaration
     
    Public Function GetColumnSortIndicator( _
       ByVal column As Integer _
    ) As SortIndicator
    'Usage
     
    Dim instance As SheetView
    Dim column As Integer
    Dim value As SortIndicator
     
    value = instance.GetColumnSortIndicator(column)
    public SortIndicator GetColumnSortIndicator( 
       int column
    )

    Parameters

    column
    Column index

    Return Value

    SortIndicator setting that determines how the sort indicator is displayed
    Example
    This example creates a SheetView object and a Column object. Values are inserted into the second column and in a button click event the column data is sorted and the sort indicator appears. The type of indicator to display is returned to a list box using the SheetView object.
    private void Page_Load(object sender, System.EventArgs e)
    {
    if(this.IsPostBack)return;
    
    FarPoint.Web.Spread.Column mycol;
    FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView;
    mycol = sv.Columns[1];
    sv.SetValue(0,1,"Alignment");
    sv.SetValue(1,1,"CarbAdjust");
    sv.SetValue(2,1,"Brakes");
    sv.AllowSort = true;
    mycol.SortIndicator = FarPoint.Web.Spread.Model.SortIndicator.Descending;
    }
    
    private void Button1_Click(object sender, System.EventArgs e)
    {
    FpSpread1.ActiveSheetView.SortRows(1, true, true);
    }
    Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs) Handles MyBase.Load
    
    If(Me.IsPostBack)Then Return
    
    Dim sv As FarPoint.Web.Spread.SheetView
    sv = FpSpread1.ActiveSheetView
    Dim mycol As FarPoint.Web.Spread.Column
    mycol = sv.Columns(1)
    sv.SetValue(0,1,"Alignment")
    sv.SetValue(1,1,"CarbAdjust")
    sv.SetValue(2,1,"Brakes")
    sv.AllowSort = True
    mycol.SortIndicator = FarPoint.Web.Spread.Model.SortIndicator.Descending
    ListBox1.Items.Add(sv.GetColumnSortIndicator(1))
    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