Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / DefaultSheetSpanModel Class / IsEmpty Method
Example


In This Topic
    IsEmpty Method (DefaultSheetSpanModel)
    In This Topic
    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
    See Also