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
Example


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.
    Syntax
    'Declaration
     
    Public Overridable Sub Remove( _
       ByVal row As Integer, _
       ByVal column As Integer _
    ) 
    'Usage
     
    Dim instance As BaseSheetSpanModel
    Dim row As Integer
    Dim column As Integer
     
    instance.Remove(row, column)
    public virtual void Remove( 
       int row,
       int column
    )

    Parameters

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