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


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

Glossary Item Box

Sets the cell note for a specified cell.

Syntax

Visual Basic (Declaration) 
Public Sub SetNote( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal note As String _
) 
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim note As String
 
instance.SetNote(row, column, note)
C# 
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.
C#Copy Code
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 BasicCopy Code
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)

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.