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

In This Topic
    AllowSort Property
    In This Topic
    Gets or sets whether users can sort rows in the sheet.
    Public Property AllowSort As Boolean
    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

    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.

    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