Gets an item in the model.

Syntax

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

Visual Basic (Usage)	Copy Code
Dim instance As ISheetSelectionModel Dim index As Integer Dim value As CellRange value = instance.Item(index)

C#
CellRange this[ int index ]; {get;}

Parameters

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

Property Value

CellRange object containing the selection

Remarks

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

Example

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

C#	Copy Code
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();

Copy Code

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

Visual Basic

Copy Code

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

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2