Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / Cell Class / Note Property
Example


In This Topic
    Note Property
    In This Topic
    Gets or sets the note for a cell.
    Syntax
    'Declaration
     
    Public Property Note As String
    'Usage
     
    Dim instance As Cell
    Dim value As String
     
    instance.Note = value
     
    value = instance.Note
    public string Note {get; set;}

    Property Value

    String containing the note for the cell
    Remarks

    You can attach a note to a cell. This text may include a comment, a question, or documentation describing the origin of the cell's value. A cell that has a note displays a small red indicator (cell note indicator) in the upper right corner of the cell. When the pointer is over a cell indicator of a cell that has a note, the cell note text displays in a box next to the cell.

    Cell notes are displayed in a similar manner as text tips. When the pointer is over the cell note indicator, the cell note text appears. For more information, refer to Adding a Note to a Cell.

    When the Spread component displays the cell note, the TextTipFetch event occurs. You can display both text tips and cell notes for a cell. For other options, refer to the TextTipPolicy property.

    You can use the CellNoteIndicatorVisible property to hide the cell note indicator when the pointer is over the cell note indicator.

    There are some limitations to the use and display of cell notes:

    • Notes cannot be placed in cells in the column or row headers.
    • The note does not display in certain cell types when the IsReservedLocation method for that cell type is set to true. This may occur in a check box cell, or in a combo box cell that is not editable, or when a cursor is over a link in a hyperlink cell.
    • The cell note indicator does not appear when the cell is in edit mode.
    • Use caution in choosing a red color as the background for a cell that could contain a cell note. The cell note indicator could be invisible against a red background.
    Example
    This example supplies a note for the cell.
    FarPoint.Win.Spread.Cell acell;
    acell = fpSpread1.ActiveSheet.Cells[0, 0];
    fpSpread1.ActiveSheet.Cells[0, 0].Text = "Note Test";
    acell.Note = "This is a note";
    Dim acell As FarPoint.Win.Spread.Cell
    acell = fpSpread1.ActiveSheet.Cells(0, 0)
    fpSpread1.ActiveSheet.Cells(0, 0).Text = "Note Test"
    acell.Note = "This is a note"
    See Also