Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / AllowSort Property
Example


In This Topic
    AllowSort Property
    In This Topic
    Gets or sets whether users can sort rows in the sheet.
    Syntax
    'Declaration
     
    Public Property AllowSort As Boolean
    'Usage
     
    Dim instance As SheetView
    Dim value As Boolean
     
    instance.AllowSort = value
     
    value = instance.AllowSort
    public bool AllowSort {get; set;}

    Property Value

    Boolean: true to allow users to sort rows; false otherwise
    Remarks

    When this property is set to true, users can double-click a column header cell to sort all the rows of a sheet according to the values in that column. Typically, a sort indicator displays in that header cell. For more information on the operation of sorting columns and rows in a sheet, refer to Customizing Sorting of Rows of User Data.

    Example
    This example allows the user to sort the sheet.
    FarPoint.Web.Spread.SheetView sv = new FarPoint.Web.Spread.SheetView();
    FpSpread1.ActiveSheetView.SetValue(0, 0, 9);
    FpSpread1.ActiveSheetView.SetValue(1, 0, 5);
    FpSpread1.ActiveSheetView.SetValue(2, 0, 7);
    sv = FpSpread1.ActiveSheetView;
    if (IsPostBack)
    {
        sv.AllowSort = true;
    }
    
    Dim sv As FarPoint.Web.Spread.SheetView
    FpSpread1.ActiveSheetView.SetValue(0, 0, 9)
    FpSpread1.ActiveSheetView.SetValue(1, 0, 5)
    FpSpread1.ActiveSheetView.SetValue(2, 0, 7)
    sv = FpSpread1.ActiveSheetView
    If IsPostBack Then
        sv.AllowSort = True
    End If
    See Also