Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / ISheetSelectionModel Interface / SetSelection Method
Row index
Column index
Number of rows in the selection
Number of columns in the selection
Example


In This Topic
    SetSelection Method (ISheetSelectionModel)
    In This Topic
    Selects the specified cells.
    Syntax
    'Declaration
     
    Sub SetSelection( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal rowCount As Integer, _
       ByVal columnCount As Integer _
    ) 
    'Usage
     
    Dim instance As ISheetSelectionModel
    Dim row As Integer
    Dim column As Integer
    Dim rowCount As Integer
    Dim columnCount As Integer
     
    instance.SetSelection(row, column, rowCount, columnCount)
    void SetSelection( 
       int row,
       int column,
       int rowCount,
       int columnCount
    )

    Parameters

    row
    Row index
    column
    Column index
    rowCount
    Number of rows in the selection
    columnCount
    Number of columns in the selection
    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