Tracking Changes

Another useful feature provided by Calc that helps you track the changes that you make to a spreadsheet (or that a colleague has made in cases where several people are working on the same spreadsheet) is Show Changes. You can turn on the recorder and then edit the spreadsheet as required.

All changes are flagged by outlining the changed cells with a red border. A note is also added to the cell, describing the change and noting the person who made the edit.

To Track Changes

1.
Select the Edit menu, then point at Changes.
2.
Select Record on the Cascading menu. This turns on the Track Changes feature.
3.
If you wish to customize the Show Changes feature (such as setting a date range for showing changes or setting a range that ...

Get StarOffice™ 5.2 Calc Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.