Gets the number of columns that contain notes.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Overridable Function GetNonEmptyNotesColumnCount() As Integer |
| C# | |
|---|
public virtual int GetNonEmptyNotesColumnCount() |
Return Value
Integer number of columns 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 Basic | 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)
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
