Calc Guide

Introduction
This chapter covers methods for editing shared documents: sharing
(collaboration), recording changes, adding comments, reviewing
changes, merging and comparing documents, and saving and using
document versions. Basic editing techniques are discussed in Chapter
2 (Entering, Editing, and Formatting Data).
Sharing documents (collaboration)
In OpenOffice.org Writer, Impress, and Draw, only one user at a time
can open any document for editing. In Calc, many users can open the
same spreadsheet for writing at the same time.
Each user who wants to collaborate should be sure to enter a name on
the Tools > Options > OpenOffice.org > User Data page.
Some menu commands are not available (grayed out) when change
tracking or document sharing is activated.
Setting up a spreadsheet for sharing
At any time, you can set up a spreadsheet for sharing with others. With
the spreadsheet document open, choose Tools > Share Document to
activate the collaboration features for this document. A dialog opens
where you can enable or disable sharing.
Figure 270: Choosing to share a spreadsheet
Chapter 11 Sharing and Reviewing Documents 323