Spread for ASP.NET 11 Product Documentation
SetNote Method (SheetView)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : SetNote Method
Row index of the cell
Column index of the cell
Text for the cell note
Sets the cell note for a specified cell.
Syntax
'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);
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)
See Also

Reference

SheetView Class
SheetView Members
GetNote Method
Note Property

User-Task Documentation

Adding a Note to a Cell