Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / DefaultSheetSpanModel Class / Clear Method / Clear() Method
Example


In This Topic
    Clear() Method
    In This Topic
    Removes all cell spans from the collection.
    Syntax
    'Declaration
 

    Public Overloads Overrides Sub Clear() 
    'Usage
 

    Dim instance As DefaultSheetSpanModel
 
instance.Clear()
    public override void Clear()
    Example
    This example adds a span to the ColumnHeaderSpanModel of the active sheet and returns the values of its methods to a list box. In the click event of a button, the span is cleared. 
    privatevoidPage_Load(objectsender,System.EventArgse)
{
if(this.IsPostBack)return;

boolb1;
FarPoint.Web.Spread.Model.CellRangerange;
FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.RowCount=10;
FpSpread1.ActiveSheetView.ColumnHeader.RowCount=3;
FarPoint.Web.Spread.Model.ISheetSpanModelmodel=FpSpread1.ActiveSheetView.ColumnHeaderSpanModel;
model.Add(0,0,3,3);
range=model.Find(2,2);
b1=model.IsEmpty();
ListBox1.Items.Add(range.ToString());
ListBox1.Items.Add(Convert.ToString(model.GetEnumerator(0,0,3,3)));
ListBox1.Items.Add(Convert.ToString(b1));
}

privatevoidButton1_Click(objectsender,System.EventArgse)
{
FarPoint.Web.Spread.Model.ISheetSpanModelmodel=FpSpread1.ActiveSheetView.ColumnHeaderSpanModel;
model.Clear();
}
    PrivateSubPage_Load(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesMyBase.Load

If(IsPostBack)ThenReturn

DimrangeAsFarPoint.Web.Spread.Model.CellRange
Dimb1AsBoolean
FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.RowCount=10
FpSpread1.ActiveSheetView.ColumnHeader.RowCount=3
DimmodelAsFarPoint.Web.Spread.Model.ISheetSpanModel=FpSpread1.ActiveSheetView.ColumnHeaderSpanModel
model.Add(0,0,3,3)
range=model.Find(2,2)
b1=model.IsEmpty()
ListBox1.Items.Add(range.ToString)
ListBox1.Items.Add(Convert.ToString(model.GetEnumerator(0,0,3,3)))
ListBox1.Items.Add(b1)
EndSub

PrivateSubButton1_Click(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesButton1.Click
DimmodelAsFarPoint.Web.Spread.Model.ISheetSpanModel=FpSpread1.ActiveSheetView.ColumnHeaderSpanModel
model.Clear()
EndSub
    See Also

    Reference

    DefaultSheetSpanModel Class
    DefaultSheetSpanModel Members
    Overload List