ExtendSelection Method (ISheetSelectionModel)

Specifies the extent (or farthest cell) in the selection of cells.

Syntax

Visual Basic
C#

'Declaration
 
Sub ExtendSelection( _
   ByVal row As Integer, _
   ByVal column As Integer _
)

'Usage
 
Dim instance As ISheetSelectionModel
Dim row As Integer
Dim column As Integer
 
instance.ExtendSelection(row, column)

void ExtendSelection( 
   int row,
   int column
)

Parameters

row: Row index of farthest cell in the selection
column: Column index of farthest cell in the selection

Example

This example adds a selection and then extends the selection to the specified column and row.

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

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

ISheetSelectionModel Interface
ISheetSelectionModel Members
SetAnchor Method
SetSelectionModel