Item Property (ISheetSelectionModel)

Visual Basic
C#

'Declaration
 
ReadOnly Default Property Item( _
   ByVal index As Integer _
) As CellRange

'Usage
 
Dim instance As ISheetSelectionModel
Dim index As Integer
Dim value As CellRange
 
value = instance.Item(index)

CellRange this[ 
   int index
]; {get;}

Parameters

index: Index of selection in the model (zero based)

Property Value

CellRange object containing the selection

Note: In C# the Item property is not available. Use the index instead.

This example returns the column index of the anchor cell of the second selection in the model.

C#

FarPoint.Win.Spread.Model.ISheetSelectionModel sel;
FarPoint.Win.Spread.Model.CellRange cr;
sel = (FarPoint.Win.Spread.Model.ISheetSelectionModel)fpSpread1.ActiveSheet.Models.Selection;
sel.AddSelection(0, 0, 2, 2);
sel.AddSelection(3, 2, 2, 4);
cr = sel[1];
label1.Text = "The first column in the second selection is " + cr.Column.ToString();

Visual Basic

Dim sel As FarPoint.Win.Spread.Model.ISheetSelectionModel
Dim cr As FarPoint.Win.Spread.Model.CellRange
sel = FpSpread1.ActiveSheet.Models.Selection
sel.AddSelection(0, 0, 2, 2)
sel.AddSelection(3, 2, 2, 4)
cr = sel.Item(1)
Label1.Text = "The first column in the second selection is " & cr.Column.ToString()

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

Reference

ISheetSelectionModel Interface
ISheetSelectionModel Members