FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 > SheetView クラス > SetColumnShowSortIndicator メソッド : SetColumnShowSortIndicator(Int32,Int32,Boolean) メソッド |
'Declaration Public Overloads Sub SetColumnShowSortIndicator( _ ByVal column As Integer, _ ByVal count As Integer, _ ByVal showIndicator As Boolean _ )
例外 | 説明 |
---|---|
System.ArgumentOutOfRangeException | 指定された列インデックスは範囲外です。有効な値は-1から列の総数までです。 |
このメソッドは、ユーザーがAutoSortColumnを実行する前に呼び出す必要があります。そうしなければ、ソートインジケータが表示され、それ以降も表示され続けます。
Random r = new Random(); int i, j; DialogResult dlg; bool b; for (i = 0; i <= 200; i++) { for (j = 0; j<=3; j++) fpSpread1.ActiveSheet.SetValue(i, j, r.Next().ToString()); } fpSpread1.ActiveSheet.SetColumnShowSortIndicator(0, 4, false); fpSpread1.ActiveSheet.AutoSortColumn(0); dlg = MessageBox.Show("Do you want to see the sort indicator?", "SetColumnShowSortIndicator", MessageBoxButtons.YesNo); if (dlg == DialogResult.Yes) { fpSpread1.ActiveSheet.SetColumnShowSortIndicator(0, 4, true); fpSpread1.ActiveSheet.AutoSortColumn(0); fpSpread1.ActiveSheet.AutoSortColumn(1); fpSpread1.ActiveSheet.AutoSortColumn(2); fpSpread1.ActiveSheet.AutoSortColumn(3); b = fpSpread1.ActiveSheet.GetColumnShowSortIndicator(0); label1.Text = "The GetColumnShowSortIndicator for column 0 = " + b.ToString(); }
Dim r As New Random() Dim i, j As Integer Dim dlg As DialogResult Dim b As Boolean For i = 0 To 20 For j = 0 To 4 FpSpread1.ActiveSheet.SetValue(i, j, r.Next.ToString()) Next j Next i FpSpread1.ActiveSheet.SetColumnShowSortIndicator(0, 4, False) FpSpread1.ActiveSheet.AutoSortColumn(0) dlg = MessageBox.Show("Do you want to see the sort indicator?", "SetColumnShowSortIndicator", MessageBoxButtons.YesNo) If dlg = DialogResult.Yes Then FpSpread1.ActiveSheet.SetColumnShowSortIndicator(0, 4, True) FpSpread1.ActiveSheet.AutoSortColumn(0) FpSpread1.ActiveSheet.AutoSortColumn(1) FpSpread1.ActiveSheet.AutoSortColumn(2) FpSpread1.ActiveSheet.AutoSortColumn(3) b = FpSpread1.ActiveSheet.GetColumnShowSortIndicator(0) Label1.Text = "The GetColumnShowSortIndicator for column 0 = " & b.ToString() End If