Spread Windows Forms 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 notes
Example
This example returns the number of columns and rows that have notes.
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())
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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.