Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / ISheetDataModel Interface / IsEmpty Method
Example


In This Topic
    IsEmpty Method (ISheetDataModel)
    In This Topic
    Determines whether the model is empty of data.
    Syntax
    'Declaration
     
    Function IsEmpty() As Boolean
    'Usage
     
    Dim instance As ISheetDataModel
    Dim value As Boolean
     
    value = instance.IsEmpty()
    bool IsEmpty()

    Return Value

    true if the cell has no data; false otherwise
    Example
    This example returns whether the model contains data.
    private void ChangeDataModel(FarPoint.Web.Spread.FpSpread ss, FarPoint.Web.Spread.Model.ISheetDataModel isd)
    {
        isd.SetValue(0, 0, "Primary");
        ss.ActiveSheetView.DataModel = (FarPoint.Web.Spread.Model.ISheetDataModel)isd;
        bool b;
        b = isd.IsEditable(0, 0);
        Response.Write("The cell can be edited is" + b.ToString());
    }
    
    private void PageLoad(object sender, System.EventArgs e)
    {
        ChangeDataModel(FpSpread1, FpSpread1.ActiveSheetView.DataModel);    
    }
    
    Private Sub ChangeDataModel(ByVal ss As FarPoint.Web.Spread.FpSpread, ByVal isd As FarPoint.Web.Spread.Model.ISheetDataModel)
        isd.SetValue(0, 0, "Primary")
        ss.ActiveSheetView.DataModel = isd
        Dim b As Boolean
        b = isd.IsEmpty()
        Response.Write("The model is empty is " & b.ToString())
    End Sub
    
    Private Sub PageLoad(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        ChangeDataModel(FpSpread1, FpSpread1.ActiveSheetView.DataModel)
    End Sub
    See Also