Spread for ASP.NET 8.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 Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.