Spread for ASP.NET 7.0 Product Documentation
GetNonEmptyNotesRowCount Method
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > DefaultSheetDataModel Class : GetNonEmptyNotesRowCount Method


Glossary Item Box

Gets the number of rows that contain notes.

Syntax

Visual Basic (Declaration) 
Public Overridable Function GetNonEmptyNotesRowCount() As Integer
Visual Basic (Usage)Copy Code
Dim instance As DefaultSheetDataModel
Dim value As Integer
 
value = instance.GetNonEmptyNotesRowCount()
C# 
public virtual int GetNonEmptyNotesRowCount()

Return Value

Integer number of rows that have cells with notes

Example

This example sets a note in some cells and returns the number of rows containing notes.
C#Copy Code
FarPoint.Web.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Web.Spread.Model.DefaultSheetDataModel(); 
dataModel = (FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel; 
dataModel.SetNote(0, 0, "Cell A1"); 
dataModel.SetNote(1, 0, "Cell A2"); 
int i; 
i = dataModel.GetNonEmptyNotesRowCount; 
Response.Write(i.ToString());
Visual BasicCopy Code
Dim dataModel As New FarPoint.Web.Spread.Model.DefaultSheetDataModel
dataModel = FpSpread1.ActiveSheetView.DataModel
dataModel.SetNote(0, 0, "Cell A1")
dataModel.SetNote(1, 0, "Cell A2")
Dim i As Integer
i = dataModel.GetNonEmptyNotesRowCount
Response.Write(i.ToString())

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.