Adding comments to changes

OpenOffice.org 3 Calc Guide

Chapter 11 Sharing and Reviewing Documents

< Previous Section

Next Section >

• Sharing documents among reviewers
• Recording changes
• Adding comments to changes
• Adding other comments
• Reviewing changes
• Merging documents
• Comparing documents
• Saving versions

< Previous Page

Next Page >

Calc automatically adds to any recorded change a comment describing what was changed (for example, Cell B4 changed from ‘9’ to ‘4’). Reviewers and authors can add their comments to explain their changes.

To add a comment to a change:

1. Make the change to the spreadsheet.
2. Select the cell with the change.
3. Choose Edit > Changes > Comments. The dialog shown below appears. The automatically-added comment provided by Calc appears in the title bar of this dialog and cannot be edited.
4. Type your own comment and click OK.

Comment dialog

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.

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 change comments

1. Select the cell with the comment that you want to edit.
2. Select Edit > Changes > Comments.
3. Edit the comment and click OK.

You can view 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.