Spread for ASP.NET 8.0 Product Documentation
GetNonEmptyNotesColumnCount Method
Example 


Gets the number of columns that contain notes.
Syntax
'Declaration
 
Public Overridable Function GetNonEmptyNotesColumnCount() As Integer
'Usage
 
Dim instance As DefaultSheetDataModel
Dim value As Integer
 
value = instance.GetNonEmptyNotesColumnCount()
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.
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());
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

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.