Spread ASP.NET 14
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
Example


In This Topic
    SetNote Method (SheetView)
    In This Topic
    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