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


In This Topic
    Remove Method (DefaultSheetSpanModel)
    In This Topic
    Removes all cell spans in the collection that include the cell at the specified row and column.
    Syntax
    'Declaration
     
    Public Overrides Sub Remove( _
       ByVal row As Integer, _
       ByVal column As Integer _
    ) 
    'Usage
     
    Dim instance As DefaultSheetSpanModel
    Dim row As Integer
    Dim column As Integer
     
    instance.Remove(row, column)
    public override void Remove( 
       int row,
       int column
    )

    Parameters

    row
    Row index of the cell
    column
    Column index of the cell
    Example
    This example adds spans to the SpanModel of the active sheet. The Remove method removes the span from the second column.
    private void Page_Load(object sender,System.EventArgs e)
    {
    if(this.IsPostBack)return;
    
    FpSpread1.ActiveSheetView.ColumnCount=10;
    FpSpread1.ActiveSheetView.RowCount=10;
    FarPoint.Web.Spread.Model.DefaultSheetSpanModel model=(FarPoint.Web.Spread.Model.DefaultSheetSpanModel)FpSpread1.ActiveSheetView.SpanModel;
    model.Add(0,0,4,1);
    model.Add(0,1,4,1);
    }
    
    private void Button1_Click(object sender,System.EventArgs e)
    {
    FarPoint.Web.Spread.Model.DefaultSheetSpanModel model=(FarPoint.Web.Spread.Model.DefaultSheetSpanModel)FpSpread1.ActiveSheetView.SpanModel;
    model.Remove(0,1);
    }
    Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.Load
    If(IsPostBack)Then Return
    
    FpSpread1.ActiveSheetView.ColumnCount=10
    FpSpread1.ActiveSheetView.RowCount=10
    Dim model As FarPoint.Web.Spread.Model.DefaultSheetSpanModel=FpSpread1.ActiveSheetView.SpanModel
    model.Add(0,0,4,1)
    model.Add(0,1,4,1)
    End Sub
    
    Private Sub Button1_Click(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles Button1.Click
    Dim model As FarPoint.Web.Spread.Model.DefaultSheetSpanModel=FpSpread1.ActiveSheetView.SpanModel
    model.Remove(0,1)
    End Sub
    See Also