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

In This Topic
    Remove Method (BaseSheetSpanModel)
    In This Topic
    Removes all cell spans in the collection that cover the cell at the specified row and column.
    Public Overridable Sub Remove( _
       ByVal row As Integer, _
       ByVal column As Integer _
    Dim instance As BaseSheetSpanModel
    Dim row As Integer
    Dim column As Integer
    instance.Remove(row, column)
    public virtual void Remove( 
       int row,
       int column


    Row index of cell
    Column index of cell
    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