LeadColumn Property (ISheetSelectionModel)

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

Syntax

Visual Basic
C#

'Declaration
 
ReadOnly Property LeadColumn As Integer

'Usage
 
Dim instance As ISheetSelectionModel
Dim value As Integer
 
value = instance.LeadColumn

int LeadColumn {get;}

Property Value

Integer column 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();
}

Visual Basic

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()

Reference

ISheetSelectionModel Interface
ISheetSelectionModel Members