CellSpanSelectionPolicy 列挙体

セル結合を扱うときの選択モデルのタイプを設定します。

構文

Visual Basic
C#

'Declaration
 
Public Enum CellSpanSelectionPolicy 
   Inherits System.Enum

public enum CellSpanSelectionPolicy : System.Enum

メンバ

メンバ	説明
Contained	ヘッダ領域に収まるセルだけを選択します。
Default	既定値（従来バージョンと同じ動作）。結合の起点の列（行）のみを選択します。
IgnoreSpan	選択時にセル結合を無視することを指定します。
Intersected	ヘッダの領域に含まれるセルをすべて選択します。

例

次のサンプルコードは、CellSpanSelectionPolicy列挙体を使用します。

C#
Visual Basic

fpSpread1.CellSpanSelectionPolicy = FarPoint.Win.Spread.CellSpanSelectionPolicy.Intersected;
fpSpread1.ActiveSheet.ColumnHeader.RowCount = 3;
// Set the number of columns in the row header.
fpSpread1.ActiveSheet.RowHeader.ColumnCount = 2;
// Define the labels for the spanned column header cells.
fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 0].Text = "East";
fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 1].Text = "West";
fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 2].Text = "East";
fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 3].Text = "West";
fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 4].Text = "East";
fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 5].Text = "West";
fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 6].Text = "East";
fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 7].Text = "West";
fpSpread1.ActiveSheet.ColumnHeader.Cells[1, 0].Text = "1st Quarter";
fpSpread1.ActiveSheet.ColumnHeader.Cells[1, 2].Text = "2nd Quarter";
fpSpread1.ActiveSheet.ColumnHeader.Cells[1, 4].Text = "3rd Quarter";
fpSpread1.ActiveSheet.ColumnHeader.Cells[1, 6].Text = "4th Quarter";
fpSpread1.ActiveSheet.ColumnHeader.Cells[0, 0].Text = "Fiscal Year 2004";
// Define the column header cell spans.
fpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 0, 1, 2);
fpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 2, 1, 2);
fpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 4, 1, 2);
fpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 6, 1, 2);
fpSpread1.ActiveSheet.AddColumnHeaderSpanCell(0, 0, 1, 8);

FpSpread1.CellSpanSelectionPolicy = FarPoint.Win.Spread.CellSpanSelectionPolicy.Intersected
FpSpread1.ActiveSheet.ColumnHeader.RowCount = 3
' Set the number of columns in the row header.
FpSpread1.ActiveSheet.RowHeader.ColumnCount = 2
' Define the labels for the spanned column header cells.
FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 0).Text = "East"
FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 1).Text = "West"
FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 2).Text = "East"
FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 3).Text = "West"
FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 4).Text = "East"
FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 5).Text = "West"
FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 6).Text = "East"
FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 7).Text = "West"
FpSpread1.ActiveSheet.ColumnHeader.Cells(1, 0).Text = "1st Quarter"
FpSpread1.ActiveSheet.ColumnHeader.Cells(1, 2).Text = "2nd Quarter"
FpSpread1.ActiveSheet.ColumnHeader.Cells(1, 4).Text = "3rd Quarter"
FpSpread1.ActiveSheet.ColumnHeader.Cells(1, 6).Text = "4th Quarter"
FpSpread1.ActiveSheet.ColumnHeader.Cells(0, 0).Text = "Fiscal Year 2004"
' Define the column header cell spans.
FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 0, 1, 2)
FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 2, 1, 2)
FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 4, 1, 2)
FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 6, 1, 2)
FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(0, 0, 1, 8)

継承階層

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.CellSpanSelectionPolicy

参照

FarPoint.Win.Spread 名前空間