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

Syntax

Visual Basic (Declaration)
Public Overridable ReadOnly Property LeadRow As Integer

Visual Basic (Usage)	Copy Code
Dim instance As BaseSheetSelectionModel Dim value As Integer value = instance.LeadRow

C#
public virtual int LeadRow {get;}

Property Value

Integer row index

Remarks

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 illustrates the use of this member by returning the row index of the last cell selected in the range.

C#	Copy Code
private void menuItem1_Click(object sender, System.EventArgs e) { FarPoint.Win.Spread.Model.BaseSheetSelectionModel selModel; int c, r; selModel = (FarPoint.Win.Spread.Model.BaseSheetSelectionModel)fpSpread1.ActiveSheet.Models.Selection; selModel.SetSelection(0, 0, 3, 3); c = selModel.LeadColumn; r = selModel.LeadRow; listBox1.Items.AddRange(new Object[] {c.ToString(), r.ToString()}); }

Copy Code

private void menuItem1_Click(object sender, System.EventArgs e)
{
FarPoint.Win.Spread.Model.BaseSheetSelectionModel selModel;
int c, r;
selModel = (FarPoint.Win.Spread.Model.BaseSheetSelectionModel)fpSpread1.ActiveSheet.Models.Selection;
selModel.SetSelection(0, 0, 3, 3);
c = selModel.LeadColumn;
r = selModel.LeadRow;
listBox1.Items.AddRange(new Object[] {c.ToString(), r.ToString()});
}

Visual Basic	Copy Code
Private Sub MenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem1.Click Dim selModel As FarPoint.Win.Spread.Model.BaseSheetSelectionModel Dim c, r As Integer selModel = FpSpread1.ActiveSheet.Models.Selection selModel.SetSelection(0, 0, 3, 3) c = selModel.LeadColumn r = selModel.LeadRow ListBox1.Items.AddRange(New Object() {c.ToString(), r.ToString()}) End Sub

Visual Basic

Copy Code

Private Sub MenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem1.Click
Dim selModel As FarPoint.Win.Spread.Model.BaseSheetSelectionModel
Dim c, r As Integer
selModel = FpSpread1.ActiveSheet.Models.Selection
selModel.SetSelection(0, 0, 3, 3)
c = selModel.LeadColumn
r = selModel.LeadRow
ListBox1.Items.AddRange(New Object() {c.ToString(), r.ToString()})
End Sub

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

Syntax

Property Value

Remarks

Example

Requirements

See Also

Reference

Spread Windows Forms 6.0 Product Documentation
LeadRow Property
See Also Example Support Options