Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / DefaultSheetDataModel Class / GetNonEmptyNotesColumnCount Method
Example


In This Topic
    GetNonEmptyNotesColumnCount Method
    In This Topic
    Gets the number of columns that contain notes.
    Syntax
    'Declaration
     
    Public Overridable Function GetNonEmptyNotesColumnCount() As Integer
    'Usage
     
    Dim instance As DefaultSheetDataModel
    Dim value As Integer
     
    value = instance.GetNonEmptyNotesColumnCount()
    public virtual int GetNonEmptyNotesColumnCount()

    Return Value

    Integer number of columns that have cells with notes
    Example
    This example sets a note in some cells and returns the number of columns containing notes.
    FarPoint.Web.Spread.Model.DefaultSheetDataModel new FarPoint.Web.Spread.Model.DefaultSheetDataModel(); 
    dataModel = (FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel; 
    dataModel.SetNote(0, 0, "Cell A1"); 
    dataModel.SetNote(0, 1, "Cell B1"); 
    int i; 
    i = dataModel.GetNonEmptyNotesColumnCount; 
    Response.Write(i.ToString());
    
    Dim dataModel As New FarPoint.Web.Spread.Model.DefaultSheetDataModel
    dataModel = FpSpread1.ActiveSheetView.DataModel
    dataModel.SetNote(0, 0, "Cell A1")
    dataModel.SetNote(0, 1, "Cell B1")
    Dim i As Integer
    i = dataModel.GetNonEmptyNotesColumnCount
    Response.Write(i.ToString())
    See Also