Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / ISheetSelectionModel Interface / Item Property
Index of the selection
Example


In This Topic
    Item Property (ISheetSelectionModel)
    In This Topic
    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