Spread Windows Forms 7.0 Product Documentation
LeadColumn Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > ISheetSelectionModel Interface : LeadColumn Property


Glossary Item Box

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

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 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.
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 BasicCopy 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

See Also

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