Spread Windows Forms 6.0 Product Documentation
GetNonEmptyNotesRowCount Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetDataModel Class : GetNonEmptyNotesRowCount Method


Glossary Item Box

Gets a count of rows containing 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 notes

Example

This example returns the number of columns and rows that have notes.
C#Copy Code
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 BasicCopy Code
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())

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

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