SetAnchor Method (ISheetSelectionModel)

Specifies the anchor (or first cell) in the selection of cells.

Syntax

Visual Basic
C#

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

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

void SetAnchor( 
   int row,
   int column
)

Parameters

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

Example

This example specifies the first cell selected in the range.

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 set the anchor?", "SetAnchor", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
sel.SetAnchor(1, 1);
sel.ExtendSelection(3, 3);
}

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 set the anchor?", "SetAnchor", MessageBoxButtons.YesNo)
If dlg = DialogResult.Yes Then
sel.SetAnchor(1, 1)
sel.ExtendSelection(3, 3)
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
ExtendSelection Method
SetSelection Method