Adding comments to changes

From OpenOffice.org Wiki

Jump to: navigation, search


Calc automatically adds a comment to any recorded change, describing what was changed (for example, Cell B4 changed from ‘9’ to ‘4’). Reviewers and authors can add their comments to communicate with each other why they made the changes.

To add a comment to a change:

  1. Make the change to the spreadsheet.
  2. Select the cell with the change.
  3. Select Edit > Changes > Comments. The dialog shown below appears. The automatically-added comment provided by Calc appear in the title bar of this dialog and cannot be edited.
  4. Type your comment and click OK.
Image:Tip.png You can step through your changes one at a time using the left and right arrows on the right hand side of the Comment dialog, and add comments to each change. The title bar for the Comment dialog shows the cell and the change you are commenting on.


Comment dialog

After you have added a comment to a changed cell, you can see it by hovering the mouse pointer over the cell.

Comment added to cell B3

The comment also appears in the dialog when you are accepting and rejecting changes.

Editing comments

  1. Select the cell with the comment that you want to edit.
  2. Select Edit > Changes > Comments. The dialog shown in Figure 4 appears.
  3. Edit the comment and click OK.
Image:Tip.png You can step through your comments one at a time using the left and right arrows on the right hand side of the Comment dialog. You do not need to click OK after editing each comment; you can save them all at once when you’re done editing.



Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools
Create a book