Gets the row index of the first cell in the selection of cells.
Syntax
Visual Basic (Declaration) | |
---|
ReadOnly Property AnchorRow As Integer |
Property Value
Integer row index
Example
This example returns the column index and row index of the first cell selected in the range.
C# | Copy Code |
---|
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 | Copy Code |
---|
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() |
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