OpenOffice.org 2.x Guía de usuario descargar pdf (Pagina 306)

100

101

Chapter 4: Spreadsheets in Calc

• While a password can be applied for protecting the sheet and the document, this is not

required. However, if a password is set, then protection can only be removed later by

entering the correct password. If no password is set, there is still effective protection

against a document being accidentally modified.

• Sheet protection prevents modification of the contents of this specific sheet. Document

protection prevents the sheets from being inserted, deleted, resorted or renamed.

• If a user has a document with confidential data that should be protected from being

opened by unauthorized persons, protect it with a password. The password makes this

protection of the entire document dependent on the protection mechanism of cells, sheets

and documents described above. To save a document with a password, select File > Save

As... and check the Save with Password check box.

Creating a Reference

If a user wants to insert a value, say the result of a profit calculation, into another sheet or

into another spreadsheet document, a reference must be created.

1. Select the cell where to insert the result

2. Enter =.

3. Next select the cell that contains the original result

4. Press Enter.

This cell can also be included in another spreadsheet or in another file. The result is

automatically inserted into the reference cell and is also updated when changes are made

later.

The content of a cell can be dragged to a cell in another document. With this action, either

choose to transfer a copy of the cell, as it now stands, into the other document or create a link

so that the other document always reflects the current content of the cell.

After setting all the necessary preferences and changes, save the document and print it.

Further Information

The document based on this template is protected. In order to make modifications in the

protected cells, first disable the protection via Tools > Protect Document > Spreadsheet.

This must be done individually for every protected sheet, including the hidden sheets.

OpenOffice.org User Guide for 2.x 272

1 2 ... 301 302 303 304 305 306 307 308 309 310 311 ... 507 508

Comentarios a estos manuales

Sin comentarios

OpenOffice.org 2.x Guía de usuario Pagina 306

Comentarios a estos manuales

Relacionado con productos y manuales para Manuales de software OpenOffice.org 2.x