Spread for ASP.NET 9.0 Product Documentation
GetNonEmptyNotesRowCount Method
Example 


Gets the number of rows that contain notes.
Syntax
'Declaration
 
Public Overridable Function GetNonEmptyNotesRowCount() As Integer
'Usage
 
Dim instance As DefaultSheetDataModel
Dim value As Integer
 
value = instance.GetNonEmptyNotesRowCount()
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.
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());
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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.