Remove Method (DefaultSheetSpanModel)

In This Topic

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

Syntax

Visual Basic
C#

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

Visual Basic

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

Reference

DefaultSheetSpanModel Class
DefaultSheetSpanModel Members
Add Method
Clear Method

Product Support Forum | Print this page