Visual Basic (Declaration) | |
---|---|
ReadOnly Property LeadRow As Integer |
Visual Basic (Usage) | ![]() |
---|---|
Dim instance As ISheetSelectionModel Dim value As Integer value = instance.LeadRow |
C# | |
---|---|
int LeadRow {get;} |
Property Value
Integer row indexIf you are selecting a range of cells, then LeadColumn and LeadRow will return the farthest cell. If you are selecting a single row or a range of rows, then LeadColumn will return 0 and LeadRow will return the farthest row. If you are selecting a column or a range of columns then LeadColumn will return the farthest column and LeadRow will return 0.
This example returns the last cell selected in the range.
C# | ![]() |
---|---|
private void menuItem89_Click(object sender, System.EventArgs e) { FarPoint.Win.Spread.Model.ISheetSelectionModel sel; int i, j; sel = (FarPoint.Win.Spread.Model.ISheetSelectionModel)fpSpread1.ActiveSheet.Models.Selection; sel.SetSelection(1, 1, 3, 4); i = sel.LeadColumn; j = sel.LeadRow; label1.Text = "The lead column in the selection is " + i.ToString() + " and the lead 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(1, 1, 3, 4) i = selectModel.LeadColumn j = selectModel.LeadRow Label1.Text = "The lead column in the selection is " & i.ToString() & " and the lead row is " & j.ToString() |
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8