Gets or sets the sort indicator for this column.
Syntax
Visual Basic (Declaration) | |
---|
Public Property SortIndicator As SortIndicator |
Visual Basic (Usage) | Copy Code |
---|
Dim instance As Column
Dim value As SortIndicator
instance.SortIndicator = value
value = instance.SortIndicator |
Property Value
SortIndicator setting
Remarks
Example
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.
C# | Copy Code |
---|
private void Page_Load(objectsender,System.EventArgse)
{
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;
}
private void Button1_Click(object sender,System.EventArgs e)
{
FpSpread1.ActiveSheetView.SortRows(1,true,true);
} |
Visual Basic | Copy Code |
---|
Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.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
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 |
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