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


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

    Return Value

    true if the model has no data; false otherwise
    Example
    This example creates a new StyleInfo object and sets the StyleInfo to cell A1. The value of the IsEmpty method is returned to a list box.
    private void Page_Load(object sender,System.EventArgs e)
    {
    if(this.IsPostBack)return;
    
    FarPoint.Web.Spread.Model.DefaultSheetStyleModel model=(FarPoint.Web.Spread.Model.DefaultSheetStyleModel)FpSpread1.Sheets[0].StyleModel;
    FarPoint.Web.Spread.StyleInfo style=new FarPoint.Web.Spread.StyleInfo();
    style.BackColor=Color.Yellow;
    
    model.SetDirectInfo(0,0,style);
    bool b=model.IsEmpty();
    ListBox1.Items.Add(b.ToString());
    ListBox1.Items.Add(model.ColumnCount.ToString());
    ListBox1.Items.Add(model.RowCount.ToString());
    }
    Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.Load
    If(IsPostBack)Then Return
    
    Dim model As FarPoint.Web.Spread.Model.DefaultSheetStyleModel=FpSpread1.Sheets(0).StyleModel
    Dim style As New FarPoint.Web.Spread.StyleInfo()
    style.BackColor=Color.Yellow
    
    model.SetDirectInfo(0,0,style)
    Dim b As Boolean=model.IsEmpty()
    ListBox1.Items.Add(b.ToString())
    ListBox1.Items.Add(model.ColumnCount.ToString())
    ListBox1.Items.Add(model.RowCount.ToString())
    End Sub
    See Also