Remove Method (BaseSheetSpanModel)

Removes all cell spans in the collection that cover the cell at the specified row and column.

Syntax

Visual Basic
C#

'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 removes any span in the model with the beginning specified cell coordinates.

private void menuItem1_Click(object sender, System.EventArgs e)
{
    FarPoint.Win.Spread.Model.BaseSheetSpanModel spanModel;
    spanModel = (FarPoint.Win.Spread.Model.BaseSheetSpanModel)fpSpread1.ActiveSheet.Models.Span;
    spanModel.Add(0, 0, 2, 2);
}

private void menuItem2_Click(object sender, System.EventArgs e)
{
    FarPoint.Win.Spread.Model.BaseSheetSpanModel spanModel;
    spanModel = (FarPoint.Win.Spread.Model.BaseSheetSpanModel)fpSpread1.ActiveSheet.Models.Span;
    spanModel.Remove(0, 0);
}

Visual Basic

Private Sub MenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem1.Click
    Dim spanModel As FarPoint.Win.Spread.Model.BaseSheetSpanModel
    spanModel = FpSpread1.ActiveSheet.Models.Span
    spanModel.Add(0, 0, 2, 2)
End Sub

Private Sub MenuItem2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem2.Click
    Dim spanModel As FarPoint.Win.Spread.Model.BaseSheetSpanModel
    spanModel = FpSpread1.ActiveSheet.Models.Span
    spanModel.Remove(0, 0)
End Sub

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

BaseSheetSpanModel Class
BaseSheetSpanModel Members