Spread Windows Forms 7.0 Product Documentation
LeadRow Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetSelectionModel Class : LeadRow Property


Glossary Item Box

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

Syntax

Visual Basic (Declaration) 
Public Overrides ReadOnly Property LeadRow As Integer
Visual Basic (Usage)Copy Code
Dim instance As DefaultSheetSelectionModel
Dim value As Integer
 
value = instance.LeadRow
C# 
public override 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 column index and row index for the last cell selected in the range.
C#Copy Code
FarPoint.Win.Spread.Model.DefaultSheetSelectionModel defselModel = new FarPoint.Win.Spread.Model.DefaultSheetSelectionModel();
int c, r;
fpSpread1.ActiveSheet.Models.Selection = defselModel;
selModel.SetSelection(0, 0, 3, 3);
c = selModel.LeadColumn;
r = selModel.LeadRow;
listBox1.Items.AddRange(new Object[] {c.ToString(), r.ToString()});
Visual BasicCopy Code
Dim defselModel As New FarPoint.Win.Spread.Model.DefaultSheetSelectionModel()
Dim c, r As Integer
defselModel = FpSpread1.ActiveSheet.Models.Selection
defselModel.SetSelection(0, 0, 3, 3)
c = defselModel.LeadColumn
r = defselModel.LeadRow
ListBox1.Items.AddRange(New Object() {c.ToString(), r.ToString()})

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

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