SetNote Method (SheetView)

Sets the cell note for a specified cell.

Syntax

Visual Basic
C#

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

'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim note As String
 
instance.SetNote(row, column, note)

public void SetNote( 
   int row,
   int column,
   string note
)

Parameters

row: Row index of the cell
column: Column index of the cell
note: Text for the cell note

Remarks

Return a cell note for a cell by calling the GetNote method. Cells with notes do not show any other indication other than displaying the note when the pointer is over the cell.

Example

This example returns the note set for the specified cell.

FarPoint.Web.Spread.SheetView sv;
string s;
sv = e.SheetView;
sv.SetNote(0, 0, "Pay Period");
s = sv.GetNote(0, 0);
Response.Write("The note for the cell is a " + s);

Visual Basic

Dim sv As FarPoint.Web.Spread.SheetView
Dim s As String
sv = FpSpread1.ActiveSheetView
sv.SetNote(0, 0, "Pay Period")
s = sv.GetNote(0, 0)
Response.Write("The note for the cell is a " & s)

Reference

SheetView Class
SheetView Members
GetNote Method
Note Property

User-Task Documentation

Adding a Note to a Cell