Spread Windows Forms 6.0 Product Documentation
AnchorRow Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > ISheetSelectionModel Interface : AnchorRow Property


Glossary Item Box

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

Syntax

Visual Basic (Declaration) 
ReadOnly Property AnchorRow As Integer
Visual Basic (Usage)Copy Code
Dim instance As ISheetSelectionModel
Dim value As Integer
 
value = instance.AnchorRow
C# 
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.
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 BasicCopy 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

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.