Gets the number of rows that contain notes.
Syntax
Visual Basic (Declaration) | |
---|
Public Overridable Function GetNonEmptyNotesRowCount() As Integer |
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 Basic | Copy 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