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 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);

Visual Basic

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)

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

BaseSheetSpanModel Class
BaseSheetSpanModel Members
Add Method