Spread ASP.NET 15
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / ISheetSpanModel Interface / Find Method
Row index of the cell.
Column index of cell.
Example


In This Topic
    Find Method (ISheetSpanModel)
    In This Topic
    Finds the cell span with the specified cell in the collection.
    Syntax
    'Declaration
     
    Function Find( _
       ByVal row As Integer, _
       ByVal column As Integer _
    ) As CellRange
    'Usage
     
    Dim instance As ISheetSpanModel
    Dim row As Integer
    Dim column As Integer
    Dim value As CellRange
     
    value = instance.Find(row, column)
    CellRange Find( 
       int row,
       int column
    )

    Parameters

    row
    Row index of the cell.
    column
    Column index of cell.

    Return Value

    CellRange object containing the cell range
    Example
    FarPoint.Web.Spread.Model.ISheetSpanModel iss;
    iss = (FarPoint.Web.Spread.Model.ISheetSpanModel)FpSpread1.ActiveSheetView.SpanModel;
    FarPoint.Web.Spread.Model.CellRange cr;
    cr = iss.Find(0, 0);
    string msg = "The first column in the span is " + cr.Column.ToString();
    Response.Write("<script language='javascript'>alert('" + msg + "')</script>");
    
    Dim iss As FarPoint.Web.Spread.Model.ISheetSpanModel
    iss = FpSpread1.ActiveSheetView.SpanModel
    Dim cr As FarPoint.Web.Spread.Model.CellRange
    cr = iss.Find(0, 0)
    Dim msg As String = "The first column in the span is " + cr.Column.ToString()
    Response.Write("<script language='javascript'>alert('" & msg & "')</script>")
    See Also