Since R1 2022 the Spreadsheet control supports working with notes. The Notes are used for making notes or annotations about the data. All notes can be found in the Notes collection of the worksheet. More information about using notes in code is available here: SpreadProcessing Notes.
Figure 1: Sample Note
Using Notes in your Application
RadSpreadsheet enables working with notes through its UI. There are two ways for adding notes, via the context menu and from the Notes menu on the review tab.
Figure 2: Add note from the context menu
Figure 3: Add note from the Notes menu
As you can see in the above image, the notes menu allows you to perform the following actions as well:
- EditNote: Puts the note of the current cell in edit mode.
- Select Previous or Next Note: Selects a note depending on the currently selected cell.
- Show/Hide Note: Shows or hides the note of the current cell.
- Show/Hide All Notes: Shows or hides all the notes in the current sheet. When enabled all notes will be visible and you will be able to select and edit them.
To edit a note select a cell that contains note and click "Edit Note" from the context menu or from the Note menu in the Review tab.
Figure 4: Edit Note
To delete a note select it and click "Delete Note" from the context menu. You can apply the "Delete Note" command on a selection of cells and if there are notes included they will be deleted as well.
Figure 4: Delete Note
Show/Hide a Note
The context menu allows you to show/hide a note as well.
Figure 5: Show/Hide Note