Spread for ASP.NET 8.0 Product Documentation
AllowSort Property
Example 


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
Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

SheetView Class
SheetView Members
GetColumnSortIndicator Method
SetColumnSortIndicator Method
Sort Method

User-Task Documentation

Customizing Sorting of Rows of User Data

 

 


Copyright © GrapeCity, inc. All rights reserved.