Calc Guide

Merging documents
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.
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, as in
Figure 288, showing changes by more than one reviewer. If you want to merge
more documents, close the dialog and then repeat steps 2 and 3.
Figure 299: 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, as shown in Figure 300. In this example, all of the changes from Robert
are blue and the changes from Mia are red.
294 OpenOffice.org 3.3 Calc Guide