Spread Windows Forms 9.0 Product Documentation
Item Property (ISheetSelectionModel)
Example 


Index of selection in the model (zero based)
Gets an item in the model.
Syntax
'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
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.
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();
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 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

See Also

Reference

ISheetSelectionModel Interface
ISheetSelectionModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.