Syntax
| Visual Basic (Declaration) | |
|---|---|
ReadOnly Property LeadColumn As Integer | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As ISheetSelectionModel Dim value As Integer value = instance.LeadColumn | |
| C# | |
|---|---|
int LeadColumn {get;} | |
Property Value
Integer column 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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8