Column プロパティ (CellRange)

Visual Basic
C#

'Declaration
 
Public ReadOnly Property Column As Integer

public int Column {get;}

プロパティ値

範囲内の最初の列のインデックスを表すInteger

この例では、CellRangeを作成し、それを使用してスプレッドシート内の選択と連結セルを設定します。次に、いくつかのIntersectメソッドは選択した範囲が指定した列および行と交差するかどうかを問い合わせ、結果をリストボックスに返します。

C#
Visual Basic

FarPoint.Web.Spread.Model.CellRange range = new FarPoint.Web.Spread.Model.CellRange(0, 0, 4, 4);
FarPoint.Web.Spread.Model.BaseSheetSelectionModel model;
model = (FarPoint.Web.Spread.Model.BaseSheetSelectionModel)FpSpread1.ActiveSheetView.SelectionModel;
FpSpread1.ActiveSheetView.SelectionBackColor = Color.Yellow;
model.AddSelection(range.Row, range.Column, range.RowCount, range.ColumnCount);
bool b, b1, b2;
FpSpread1.ActiveSheetView.ColumnCount = 10;
FpSpread1.ActiveSheetView.RowCount = 10;
FpSpread1.ActiveSheetView.AddSpanCell(range.Row, range.Column, range.RowCount, range.ColumnCount);
b = range.IntersectColumn(1);
b1 = range.IntersectRow(1);
b2 = range.Intersects(0, 0, 4, 4);
ListBox1.Items.Add(Convert.ToString(b));
ListBox1.Items.Add(Convert.ToString(b1));
ListBox1.Items.Add(Convert.ToString(b2));

Dim range As New FarPoint.Web.Spread.Model.CellRange(1, 1, 4, 4)
Dim range1 As New FarPoint.Web.Spread.Model.CellRange(0, 0, 4, 4)
Dim model As FarPoint.Web.Spread.Model.BaseSheetSelectionModel
model = FpSpread1.ActiveSheetView.SelectionModel
FpSpread1.ActiveSheetView.SelectionBackColor = Color.Yellow
model.AddSelection(range.Row, range.Column, range.RowCount, range.ColumnCount)
Dim b, b1, b2 As Boolean
FpSpread1.ActiveSheetView.ColumnCount = 10
FpSpread1.ActiveSheetView.RowCount = 10
FpSpread1.ActiveSheetView.AddSpanCell(range.Row, range.Column, range.RowCount, range.ColumnCount)
b = range.IntersectColumn(1)
b1 = range.IntersectRow(1)
b2 = range.Intersects(0, 0, 4, 4)
ListBox1.Items.Add(b)
ListBox1.Items.Add(b1)
ListBox1.Items.Add(b2)

CellRange クラス
 CellRange メンバ