Sets the note for a 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.



You can add a note to a cell or range of cells. The note may contain text such as a comment, a question, or documentation describing the origin of the cell's value. Each cell with a note attached displays a cell note indicator (by default a small red square) in the upper right corner of the cell. When the pointer is over a cell indicator of a cell that has a note, the note text displays in a box next to the cell.


Cell Note


The red square in the upper right corner of the cell indicates that a note is available for that cell. An example is shown in the figure below. You can use the CellNoteIndicatorVisible property of DataBook to hide the cell note indicator when the pointer is over the cell note indicator.


Cell Note Indicator



Customizing the Cell Note Behavior

By default, a cell note remains displayed, as if it were a sticky note. In this case they appear in a rectangle next to the cell with an expandable line that attaches the note to the cell, allowing the note to be moved by the user. An example of a sticky note that has been selected is shown in the figure below. The sticky note in this case is a shape that can be moved.


Sticky Note Example


In order to move the note, left click the mouse button when the pointer is on the note to select it, drag it to the destination, and release the mouse button to place it. The line from the cell note indicator to the sticky note stretches to accommodate any placement of the note.


You can allow the user to edit cell notes if the notes are always shown. To allow the user to edit it, set the AllowNoteEdit property for the DataSheet, which sets all sticky notes on that sheet to be editable by the user.