Spread for ASP.NET 7.0 Product Documentation
GetNonEmptyNotesColumnCount Method
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > DefaultSheetDataModel Class : GetNonEmptyNotesColumnCount Method


Glossary Item Box

Gets the number of columns that contain notes.

Syntax

Visual Basic (Declaration) 
Public Overridable Function GetNonEmptyNotesColumnCount() As Integer
Visual Basic (Usage)Copy Code
Dim instance As DefaultSheetDataModel
Dim value As Integer
 
value = instance.GetNonEmptyNotesColumnCount()
C# 
public virtual int GetNonEmptyNotesColumnCount()

Return Value

Integer number of columns that have cells with notes

Example

This example sets a note in some cells and returns the number of columns containing notes.
C#Copy Code
FarPoint.Web.Spread.Model.DefaultSheetDataModel new FarPoint.Web.Spread.Model.DefaultSheetDataModel(); 
dataModel = (FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel; 
dataModel.SetNote(0, 0, "Cell A1"); 
dataModel.SetNote(0, 1, "Cell B1"); 
int i; 
i = dataModel.GetNonEmptyNotesColumnCount; 
Response.Write(i.ToString());
Visual BasicCopy Code
Dim dataModel As New FarPoint.Web.Spread.Model.DefaultSheetDataModel
dataModel = FpSpread1.ActiveSheetView.DataModel
dataModel.SetNote(0, 0, "Cell A1")
dataModel.SetNote(0, 1, "Cell B1")
Dim i As Integer
i = dataModel.GetNonEmptyNotesColumnCount
Response.Write(i.ToString())

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

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