AnchorRow Property (ISheetSelectionModel)

In This Topic

Gets the row index of the first cell in the selection of cells.

Syntax

Visual Basic
C#

'Declaration
 
ReadOnly Property AnchorRow As Integer

'Usage
 
Dim instance As ISheetSelectionModel
Dim value As Integer
 
value = instance.AnchorRow

int AnchorRow {get;}

Property Value

Integer row index

Example

This example returns the column index and row index of the first cell selected in the range.

FarPoint.Win.Spread.Model.ISheetSelectionModel sel;
int i, j;
sel = (FarPoint.Win.Spread.Model.ISheetSelectionModel)fpSpread1.ActiveSheet.Models.Selection;
sel.SetSelection(0, 0, 2, 2);
i = sel.AnchorColumn;
j = sel.AnchorRow;
label1.Text = "The anchor column is " + i.ToString() + " - The anchor row is " + j.ToString();

Visual Basic

Dim sel As FarPoint.Win.Spread.Model.ISheetSelectionModel
Dim i, j As Integer
sel = FpSpread1.ActiveSheet.Models.Selection
sel.SetSelection(0, 0, 2, 2)
i = sel.AnchorColumn
j = sel.AnchorRow
Label1.Text = "The anchor column is " & i.ToString() & " - The anchor row is " & j.ToString()

Reference

ISheetSelectionModel Interface
ISheetSelectionModel Members

Product Support Forum | Print this page