FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class > AutoSortColumn Method : AutoSortColumn(Int32,Boolean,Boolean) Method |
'Declaration Public Overloads Sub AutoSortColumn( _ ByVal column As Integer, _ ByVal ascending As Boolean, _ ByVal showIndicator As Boolean _ )
This example sets whether to allow automatic sorting in the specified column, if it should be sorted in ascending order, and whether to show the sort indicator.
Random r = new Random(); int i, j; for (i = 0; i<= 50; i++) { for (j = 0; j<=3; j++) fpSpread1.ActiveSheet.SetValue(i, j, r.Next(1, 200).ToString()); } fpSpread1.ActiveSheet.AutoSortColumn(0, true, false);
Dim r As New Random() Dim i, j As Integer For i = 0 To 50 For j = 0 To 3 FpSpread1.ActiveSheet.SetValue(i, j, r.Next(1, 200).ToString()) Next j Next i FpSpread1.ActiveSheet.AutoSortColumn(0, True, False)
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10