Notes
| Minimum Version | R1 2022 |
|---|
RadSpreadProcessing supports working with notes. Notes are used for making annotations about the data. All notes are available in the NoteCollection of the worksheet. This collection holds SpreadsheetNote objects which represent the notes. Each note has the following properties:
CellIndex: Gets or sets the cell index where the top left corner of the shape is positioned.RelatedCellIndex: Gets or sets the cell index assigned to the note.AlternateText: Gets or sets the alternate text.IsVisible: Gets or sets a value indicating whether thisSpreadsheetNoteis visible.OffsetX: Gets or sets the left offset of the top left corner of the shape relative to the top left corner of the cell index.OffsetY: Gets or sets the top offset of the top left corner of the shape relative to the top left corner of the cell index.Width: Gets or sets the width of the shape.Height: Gets or sets the height of the shape.MoveWithCells: Gets or sets a value indicating whether thisSpreadsheetNotemoves with its underlying cells.SizeWithCells: Gets or sets a value indicating whether thisSpreadsheetNoteresizes with its underlying cells.Author: Gets or sets the author assigned to the note.Text: Gets or sets the text.Id: Gets the id of the shape, which is unique for the worksheet it belongs to.Name: Gets or sets the name of the shape.LockAspectRatio: Gets or sets the value indicating whether the aspect ratio between the width and height remains constant.
All of the listed properties push a change to the undo stack when modified.
Working with the NoteCollection
Adding Notes
To add a note, specify the cell index to which the note relates, the position where the note appears, the author, and the text content. The position is optional. By default, the note is placed next to the related cell.
Example 1: Add Note
CellIndex relatedCellIndex = new CellIndex(1, 1);
CellIndex cellIndex = new CellIndex(5, 5);
string author = "John Doe";
string text = "Comment Content";
worksheet.Notes.Add(relatedCellIndex, cellIndex, author, text);
The previous snippet adds a note in cell B2 with a position on cell F6.
Removing Notes
Example 2: Remove Note
var note = worksheet.Notes[0];
worksheet.Notes.Remove(note);
Hide and Show Notes
You can use one of the following methods to show or hide single or all notes:
ShowAll: Shows all notes in the collection.HideAll: Hides all notes in the collection.Hide(SpreadsheetNote note): Hides the specified note from the collection.Show(SpreadsheetNote note): Shows the specified note from the collection.
Example 3: Hide Note
var note = worksheet.Notes[0];
worksheet.Notes.Hide(note);
Events
The notes collection exposes the following events:
Changing: Occurs when the collection is changing.Changed: Occurs when the collection has changed.NotesVisibilityChanged: Occurs when the visibility of all notes changes at the same time.