Removes all cell spans from the collection.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Overloads Overrides Sub Clear() |
| C# | |
|---|
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.
| C# |  Copy Code |
|---|
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();
} |
| Visual Basic | Copy Code |
|---|
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 |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
