Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




OpenOffice Calc 3.x Guide
Previous Page Home Next Page

You submitted your budget proposal to your sponsor, but you sent it to one of your assistant coaches as well. Both of them returned their revised budget to you at the same time.

You could review each document and the changes separately, but to save time, you want to see both of their revisions simultaneously.

To do this, you can use Calc’s merge document feature.

The processes discussed to this point are effective when you have one reviewer at a time. Sometimes, however, multiple reviewers all return edited versions of a document at the same time. In this case, it may be quicker to review all of these changes at once, rather than one review at a time. For this purpose, you can merge documents in Calc.

To merge documents, all of the edited documents need to have recorded changes in them.

  1. Open the original document.
  2. Select Edit > Changes > Merge Document.
  3. A file selection dialog opens. Select a file you want to merge and click OK.
  4. After the documents merge, the Accept or Reject Changes dialog opens, showing changes by more than one reviewer. If you want to merge more documents, close the dialog and then repeat steps 2 and 3.
Accept or reject for merged documents

Now all of the changes are combined into one document and you can accept or reject the changes. Changes from different authors appear in different colors in the document. In this example, all of the changes from Peter are blue and the changes from Gina are red.

Merged documents with different author colors

OpenOffice Calc 3.x Guide
Previous Page Home Next Page

  Published under the terms of the Creative Commons License Design by Interspire