Spread ASP.NET 15
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / BaseSheetSpanModel Class / Find Method
Row index of cell
Column index of cell

In This Topic
    Find Method (BaseSheetSpanModel)
    In This Topic
    Finds the cell span in the collection that includes the cell at the specified row and column.
    Public Overridable Function Find( _
       ByVal row As Integer, _
       ByVal column As Integer _
    ) As CellRange
    Dim instance As BaseSheetSpanModel
    Dim row As Integer
    Dim column As Integer
    Dim value As CellRange
    value = instance.Find(row, column)
    public virtual CellRange Find( 
       int row,
       int column


    Row index of cell
    Column index of cell

    Return Value

    CellRange object containing the cell range that has the cell at the specified row and column
    This example finds the span in the model with the specified row and column.
    FarPoint.Web.Spread.Model.BaseSheetSpanModel bss;
    FarPoint.Web.Spread.Model.CellRange cr;
    bss = (FarPoint.Web.Spread.Model.BaseSheetSpanModel)FpSpread1.ActiveSheetView.SpanModel;
    bss.Add(0, 0, 2, 2);
    bss.Add(1, 2, 2, 2);
    Response.Write("<script>alert('Find Span?')</script>");
    cr = bss.Find(1, 2);
    Response.Write("<script>alert('Remove Span?')</script>");
    bss.Remove(cr.Row, cr.Column);
    Dim bss As FarPoint.Web.Spread.Model.BaseSheetSpanModel
    Dim cr As FarPoint.Web.Spread.Model.CellRange
    bss = FpSpread1.ActiveSheetView.SpanModel
    bss.Add(0, 0, 2, 2)
    bss.Add(1, 2, 2, 2)
    Response.Write("<script>alert('Find Span?')</script>")
    cr = bss.Find(1, 2)
    Response.Write("<script>alert('Remove Span?')</script>")
    bss.Remove(cr.Row, cr.Column)
    See Also