Spread for ASP.NET 9.0 Product Documentation
IsEmpty Method (DefaultSheetSpanModel)
Example 


Determines whether the model is empty of cell spans.
Syntax
'Declaration
 
Public Overrides Function IsEmpty() As Boolean
'Usage
 
Dim instance As DefaultSheetSpanModel
Dim value As Boolean
 
value = instance.IsEmpty()
public override bool IsEmpty()

Return Value

true if there are no cell spans; false otherwise
Example
This example adds a span to the ColumnHeaderSpanModel of the active sheet. In the click event of a button, the span is removed.
private void Page_Load(object sender,System.EventArgs e)
{
if(this.IsPostBack)return;

bool b1;
FarPoint.Web.Spread.Model.CellRange range;
FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.RowCount=10;
FpSpread1.ActiveSheetView.ColumnHeader.RowCount=3;
FarPoint.Web.Spread.Model.ISheetSpanModel model=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));
}

private void Button1_Click(object sender,System.EventArgs e)
{
FarPoint.Web.Spread.Model.ISheetSpanModel model=FpSpread1.ActiveSheetView.ColumnHeaderSpanModel;
model.Remove(0,0);
}
Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.Load

If(IsPostBack)Then Return

Dim range As FarPoint.Web.Spread.Model.CellRange
Dim b1 As Boolean
FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.RowCount=10
FpSpread1.ActiveSheetView.ColumnHeader.RowCount=3
Dim model As FarPoint.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)
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.ISheetSpanModel=FpSpread1.ActiveSheetView.ColumnHeaderSpanModel
model.Remove(0,0)
End Sub
Requirements

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

See Also

Reference

DefaultSheetSpanModel Class
DefaultSheetSpanModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.