FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetDataModel Class : GetNonEmptyNotesRowCount Method |
'Declaration Public Overridable Function GetNonEmptyNotesRowCount() As Integer
'Usage Dim instance As DefaultSheetDataModel Dim value As Integer value = instance.GetNonEmptyNotesRowCount()
public virtual int GetNonEmptyNotesRowCount()
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())
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8