GetNonEmptyNotesRowCount Method

Visual Basic
C#

'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 notes

This example returns the number of columns and rows that have notes.

C#

fpSpread1.ActiveSheet.ColumnCount = 5;
fpSpread1.ActiveSheet.RowCount = 5;
fpSpread1.ActiveSheet.Cells[0, 0, 4, 4].Text = "This is a note test!";
fpSpread1.ActiveSheet.SetNote(0, 0, "I am a note!");
fpSpread1.ActiveSheet.SetNote(1, 1, "I am a note!");
fpSpread1.ActiveSheet.SetNote(2, 2, "I am a note!");
fpSpread1.ActiveSheet.SetNote(3, 3, "I am a note!");
fpSpread1.ActiveSheet.ShowNotes(true);

int r, c;
FarPoint.Win.Spread.Model.DefaultSheetDataModel dm;
dm = fpSpread1.ActiveSheet.Models.Data;
c = dm.GetNonEmptyNotesColumnCount;
r = dm.GetNonEmptyNotesRowCount;
MessageBox.Show(c.ToString() + " - " + r.ToString())

Visual Basic

FpSpread1.ActiveSheet.ColumnCount = 5
FpSpread1.ActiveSheet.RowCount = 5
FpSpread1.ActiveSheet.Cells(0, 0, 4, 4).Text = "This is a note test!"
FpSpread1.ActiveSheet.SetNote(0, 0, "I am a note!")
FpSpread1.ActiveSheet.SetNote(1, 1, "I am a note!")
FpSpread1.ActiveSheet.SetNote(2, 2, "I am a note!")
FpSpread1.ActiveSheet.SetNote(3, 3, "I am a note!")
FpSpread1.ActiveSheet.ShowNotes(True)

Dim r, c As Integer
Dim dm As FarPoint.Win.Spread.Model.DefaultSheetDataModel
dm = FpSpread1.ActiveSheet.Models.Data
c = dm.GetNonEmptyNotesColumnCount
r = dm.GetNonEmptyNotesRowCount
MessageBox.Show(c.ToString() & " - " & r.ToString())

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members