Spread Windows Forms 11.0 Product Documentation
LeadRow Property (ISheetSelectionModel)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > ISheetSelectionModel Interface : LeadRow Property
Gets the row index of the farthest cell in the selection of cells.
Syntax
'Declaration
 
ReadOnly Property LeadRow As Integer
'Usage
 
Dim instance As ISheetSelectionModel
Dim value As Integer
 
value = instance.LeadRow
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 returns the last cell selected in the range.
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();
} 
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()
See Also

Reference

ISheetSelectionModel Interface
ISheetSelectionModel Members