AddSelection メソッド (ISheetSelectionModel)

Visual Basic
C#

'Declaration
 
Sub AddSelection( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer _
)

'使用法
 
Dim instance As ISheetSelectionModel
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
 
instance.AddSelection(row, column, rowCount, columnCount)

void AddSelection( 
   int row,
   int column,
   int rowCount,
   int columnCount
)

パラメータ

row: 追加する最初のセルの行インデックス
column: 追加する最初のセルの列インデックス
rowCount: 追加する行数
columnCount: 追加する列数

次のサンプルコードは、選択範囲を追加し、その選択範囲を指定した列および行まで拡張します。

C#

FarPoint.Win.Spread.Model.ISheetSelectionModel sel;
DialogResult dlg;
sel = (FarPoint.Win.Spread.Model.ISheetSelectionModel)fpSpread1.ActiveSheet.Models.Selection;
sel.AddSelection(0, 0, 2, 2);
dlg = MessageBox.Show("Do you want to extend the selection?", "ExtendSelection", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
sel.ExtendSelection(4, 4);
}

Visual Basic

Dim sel As FarPoint.Win.Spread.Model.ISheetSelectionModel
Dim dlg As DialogResult
sel = FpSpread1.ActiveSheet.Models.Selection
sel.AddSelection(0, 0, 2, 2)
dlg = MessageBox.Show("Do you want to extend the selection?", "ExtendSelection", MessageBoxButtons.YesNo)
If dlg = DialogResult.Yes Then
sel.ExtendSelection(4, 4)
End If

ISheetSelectionModel インタフェース
 ISheetSelectionModel メンバ