Spread for ASP.NET 11 Product Documentation
Item Property (ISheetSelectionModel)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > ISheetSelectionModel Interface : Item Property
Index of the selection
Gets a selection 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 the selection

Property Value

CellRange object containing the range of the selected cells
Remarks
A selection is a selected range of cells.
Example
FarPoint.Web.Spread.Model.ISheetSelectionModel iss;
iss = (FarPoint.Web.Spread.Model.ISheetSelectionModel)FpSpread1.ActiveSheetView.SelectionModel;
iss.SetSelection(0, 0, 2, 2);
FarPoint.Web.Spread.Model.CellRange cr = iss[0];
string msg = "The first column in the selection is " + cr.Column.ToString();
Response.Write("<script language='javascript'>alert('" + msg + "')</script>");
Dim iss As FarPoint.Web.Spread.Model.ISheetSelectionModel
iss = FpSpread1.ActiveSheetView.SelectionModel
iss.SetSelection(0, 0, 2, 2)
Dim cr As FarPoint.Web.Spread.Model.CellRange = iss.Item(0)
Dim msg As String = "The first column in the selection is " + cr.Column.ToString()
Response.Write("<script language='javascript'>alert('" & msg & "')</script>")
See Also

Reference

ISheetSelectionModel Interface
ISheetSelectionModel Members