Clear Method (ISheetSpanModel) | Spread Windows Forms 13.0 Product Documentation

Clear Method (ISheetSpanModel)

In This Topic

Removes all cell spans from the collection.

Syntax

Visual Basic
C#

'Declaration
 
Sub Clear()

'Usage
 
Dim instance As ISheetSpanModel
 
instance.Clear()

void Clear()

Example

This example removes all of the spans from the model.

FarPoint.Win.Spread.Model.ISheetSpanModel sp;
DialogResult dlg;
sp = (FarPoint.Win.Spread.Model.ISheetSpanModel)fpSpread1.ActiveSheet.Models.Span;
sp.Add(0, 0, 2, 2);
sp.Add(0, 3, 2, 2);
dlg = MessageBox.Show("Do you want to remove all the spans??", "Clear", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
     sp.Clear();
}

Visual Basic

Dim sp As FarPoint.Win.Spread.Model.ISheetSpanModel
Dim dlg As DialogResult
sp = FpSpread1.ActiveSheet.Models.Span
sp.Add(0, 0, 2, 2)
sp.Add(0, 3, 2, 2)
dlg = MessageBox.Show("Do you want to remove all the spans??", "Clear", MessageBoxButtons.YesNo)
If dlg = DialogResult.Yes Then
     sp.Clear()
End If

Reference

ISheetSpanModel Interface
ISheetSpanModel Members

Product Support Forum | Print this page