ComplexSortInfo コンストラクタ(Int32,Color,Boolean,Boolean)

指定したソート順序とSPREADのデフォルトの色比較子によって処理される比較を含むComplexSortInfoオブジェクトを作成します。

構文

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal index As Integer, _
   ByVal color As Color, _
   ByVal isForeColor As Boolean, _
   ByVal ascending As Boolean _
)

'使用法
 
Dim index As Integer
Dim color As Color
Dim isForeColor As Boolean
Dim ascending As Boolean
 
Dim instance As New ComplexSortInfo(index, color, isForeColor, ascending)

public ComplexSortInfo( 
   int index,
   Color color,
   bool isForeColor,
   bool ascending
)

パラメータ

index: ソートする列または行のインデックス
color: 比較する基本色
isForeColor: 基本色が前景色かどうか
ascending: ソート順序が昇順かどうか

例

次のサンプルコードは、カラー値のソートオプションを追加します。

C#
Visual Basic

FarPoint.Win.Spread.TableStyle tstyle = fpSpread1.CreateTableStyle("Style1", FarPoint.Win.Spread.TableStyle.None);
fpSpread1.Sheets[0].Cells[1, 1].Text = "Last Name";
fpSpread1.Sheets[0].Cells[1, 2].Text = "Value";
fpSpread1.Sheets[0].Cells[2, 1].Text = "Smith";
fpSpread1.Sheets[0].Cells[2, 1].ForeColor = Color.Aqua;
fpSpread1.Sheets[0].Cells[2, 2].Value = 50;
fpSpread1.Sheets[0].Cells[3, 1].Text = "Vil";
fpSpread1.Sheets[0].Cells[3, 1].ForeColor = Color.Black;
fpSpread1.Sheets[0].Cells[3, 2].Value = 10;
fpSpread1.Sheets[0].Cells[4, 1].Text = "Press";
fpSpread1.Sheets[0].Cells[4, 1].ForeColor = Color.DarkBlue;
fpSpread1.Sheets[0].Cells[4, 2].Value = 78;         
FarPoint.Win.Spread.ComplexSortInfo[] sort = new FarPoint.Win.Spread.ComplexSortInfo[1];
sort[0] = new FarPoint.Win.Spread.ComplexSortInfo(1, System.Drawing.Color.Black, true, true);
FarPoint.Win.Spread.TableView table = fpSpread1.Sheets[0].AddTable("table", 1, 1, 5, 2, "Style1");
table.Sort(sort);

Dim tstyle As FarPoint.Win.Spread.TableStyle
tstyle = FpSpread1.CreateTableStyle("Style1", FarPoint.Win.Spread.TableStyle.None)
FpSpread1.Sheets(0).Cells(1, 1).Text = "Last Name"
FpSpread1.Sheets(0).Cells(1, 2).Text = "Value"
FpSpread1.Sheets(0).Cells(2, 1).Text = "Smith"
FpSpread1.Sheets(0).Cells(2, 1).ForeColor = Color.Aqua
FpSpread1.Sheets(0).Cells(2, 2).Value = 50
FpSpread1.Sheets(0).Cells(3, 1).Text = "Vil"
FpSpread1.Sheets(0).Cells(3, 1).ForeColor = Color.Black
FpSpread1.Sheets(0).Cells(3, 2).Value = 10
FpSpread1.Sheets(0).Cells(4, 1).Text = "Press"
FpSpread1.Sheets(0).Cells(4, 1).ForeColor = Color.DarkBlue
FpSpread1.Sheets(0).Cells(4, 2).Value = 78
FpSpread1.TableStyleCollection.Add(tstyle)
Dim table As FarPoint.Win.Spread.TableView = FpSpread1.Sheets(0).AddTable("table", 1, 1, 5, 2, "Style1")
Dim sort As FarPoint.Win.Spread.ComplexSortInfo() = New FarPoint.Win.Spread.ComplexSortInfo(0) {}
sort(0) = New FarPoint.Win.Spread.ComplexSortInfo(1, System.Drawing.Color.Black, True, True)
table.Sort(sort)

参照

ComplexSortInfo クラス
 ComplexSortInfo メンバ
 オーバーロード一覧