Gets or sets the sort indicator for this column.
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
