FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 > SheetView クラス > SetColumnAllowAutoSort メソッド : SetColumnAllowAutoSort(Int32,Int32,Boolean) メソッド |
'Declaration Public Overloads Sub SetColumnAllowAutoSort( _ ByVal column As Integer, _ ByVal count As Integer, _ ByVal allowAutoSort As Boolean _ )
例外 | 説明 |
---|---|
System.ArgumentOutOfRangeException | 指定された列インデックスは範囲外です。有効な値は-1から列の総数までです。 |
Random r = new Random(); int i, j; bool b; for (i = 0; i <= 200; i++) { for (j = 0; j<=3; j++) fpSpread1.ActiveSheet.SetValue(i, j, r.Next().ToString()); } fpSpread1.ActiveSheet.SetColumnAllowAutoSort(0, 4, true); b = fpSpread1.ActiveSheet.GetColumnAllowAutoSort(0); label1.Text = "GetColumnAllowAutoSort = " + b.ToString() + " - Click on the column headers to sort.";
Dim r As New Random() Dim i, j As Integer Dim b As Boolean For i = 0 To 50 For j = 0 To 3 FpSpread1.ActiveSheet.SetValue(i, j, r.Next.ToString()) Next j Next i FpSpread1.ActiveSheet.SetColumnAllowAutoSort(0, 4, True) b = FpSpread1.ActiveSheet.GetColumnAllowAutoSort(0) Label1.Text = "GetColumnAllowAutoSort = " & b.ToString() & " - Click on the column headers to sort."