Comments
Add a comment (a note) to a cell, using the context menu, just like in Excel. Edit and delete comments. Make comments read-only.
Enable the plugin
Set the comments configuration option to true to enable the feature and add all the needed context menu items. For example:
After you've enabled the plugin, the Context Menu gains a few new items:
- Add/Edit comment
- Delete comment
- Read-only comment
You can also pre-define comments for your table. Comments are stored in the table's/column's/cell's metadata object and you can declare as any value of the respective type. For example:
In this example, the comment "Hello world!" is added to the cell at (1,1).
Basic example
By default, all comments are editable. To change this, set the readOnly configuration option to true when adding a comment. This example makes the "Tesla" comment attached to a cell read-only, whereas the "Honda" comment attached to another cell is editable.
To set the width and height of a comment box, use the style parameter.
To display comments after a pre-configured time delay, use the displayDelay parameter.
| Windows | macOS | Action | Excel | Sheets |
|---|---|---|---|---|
| Ctrl+Alt+M | Ctrl+Option+M | Add or edit a comment | ✗ | ✓ |
| Ctrl+Enter | Cmd+Enter | Save and exit the current comment | ✗ | ✓ |
| Escape | Escape | Exit the current comment without saving | ✗ | ✗ |
- Configuration options: