OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido descargar pdf (Pagina 160)

Sharing content between sheets

You might want to enter the same information in the same cell on

multiple sheets, for example to set up standard listings for a group of

individuals or organizations. Instead of entering the list on each sheet

individually, you can enter it in all the sheets at once. To do this, select

all the sheets (Edit > Sheet > Select), then enter the information in

the current one.

Caution

This technique overwrites any information that is already in

the cells on the other sheets—without any warning. For this

reason, when you are finished, be sure to deselect all the

sheets except the one you want to edit. (Ctrl+click on a sheet

tab to select or deselect the sheet.)

Validating cell contents

When creating spreadsheets for other people to use, you may want to

make sure they enter data that is valid or appropriate for the cell. You

can also use validity in your own work as a guide to entering data that

is either complex or rarely used.

Fill series and selection lists can handle some types of data, but they

are limited to predefined information. For a more general case, you can

select a cell and use Data > Validity to define the type of contents

that can be entered in that cell. For example, a cell might require a

date or a whole number, with no alphabetic characters or decimal

points; or a cell may not be blank.

Depending on how validity is set up, the tool can also define the range

of contents that can be entered and provide help messages that explain

the content rules you have set up for the cell and what users should do

when they enter invalid content. You can also set the cell to refuse

invalid content, accept it with a warning, or start a macro when an

error is entered.

See Chapter 2 in the Calc Guide for more information.

Editing data

Editing data is done is in much the same way as it is entered. The first

step is selecting the cell containing the data to be edited.

160 Getting Started with OpenOffice.org 3.x

Free eBook Edition

1 2 ... 155 156 157 158 159 160 161 162 163 164 165 ... 441 442

OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido Pagina 160