Syntax
| Visual Basic (Declaration) | |
|---|---|
ReadOnly Property LeadRow As Integer | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As ISheetSelectionModel Dim value As Integer value = instance.LeadRow | |
| C# | |
|---|---|
int LeadRow {get;} | |
Property Value
Integer row indexRemarks
If 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.
Example
This example returns the last cell selected in the range.
| C# | Copy Code |
|---|---|
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 | Copy Code |
|---|---|
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() | |
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