Spread Windows Forms 11.0 Product Documentation
LeadColumn Property (DefaultSheetSelectionModel)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetSelectionModel Class : LeadColumn Property
Gets the column index of the farthest cell of the selection.
Syntax
'Declaration
 
Public Overrides ReadOnly Property LeadColumn As Integer
'Usage
 
Dim instance As DefaultSheetSelectionModel
Dim value As Integer
 
value = instance.LeadColumn
public override 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 illustrates the use of this member by returning the column index and row index for the last cell selected in the range.
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()});
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()})
See Also

Reference

DefaultSheetSelectionModel Class
DefaultSheetSelectionModel Members