Specifies the anchor (or first cell) in the selection of cells.
Syntax
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.
C# | Copy Code |
---|
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 | Copy Code |
---|
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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also