SetNote Method (BaseSheetDataModel)

Sets the note for a cell at a specified row and column.

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable Sub SetNote( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal value As String _
)

'Usage
 
Dim instance As BaseSheetDataModel
Dim row As Integer
Dim column As Integer
Dim value As String
 
instance.SetNote(row, column, value)

public virtual void SetNote( 
   int row,
   int column,
   string value
)

Parameters

row: Row index
column: Column index
value: String for note

Example

This example returns the note set for the specified column and row.

FarPoint.Web.Spread.Model.BaseSheetDataModel bdm;
string s;
bdm = (FarPoint.Web.Spread.Model.BaseSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
bdm.SetNote(0, 0, "TestNote")
s = bdm.GetNote(0, 0);
Response.Write("The note is " + s);

Visual Basic

Dim bdm As FarPoint.web.Spread.Model.BaseSheetDataModel
Dim s As String
bdm = FpSpread1.ActiveSheetView.DataModel
bdm.SetNote(0, 0, "TestNote")
s = bdm.GetNote(0, 0)
Response.Write("The note is " & s)

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

BaseSheetDataModel Class
BaseSheetDataModel Members
GetNote Method