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

Chapter 4: Spreadsheets in Calc

Absolute references are used when a calculation refers to one specific cell in the sheet. For

example, if a formula that refers to exactly this cell is copied relatively to a cell below the

original cell, the reference will also be moved down if the cell coordinates are not defined as

absolute. Aside from when new rows and columns are inserted, references can also change

when an existing formula referring to particular cells is copied to another area of the sheet.

Assume, for example, the formula =SUM(A1:A9) is entered in row 10 but the calculated

sum must be in the adjacent column to the right. In this case, simply copy this formula to the

cell to the right. The copy of the formula in column B will be automatically adjusted to

=SUM(B1:B9).

There are many methods to copy a formula, one of which is:

1. Select the cell containing the formula.

2. Choose Edit > Copy, or press Ctrl+ C to copy it.

3. Select the cell into which the formula is to be copied.

4. Choose Edit > Paste, or press Ctrl+V. The formula will be positioned in the new cell,

and all non-absolute references will be updated.

Copying a formula into multiple cells can be quick and easy. One way to copy into adjacent

cell areas is as follows:

1. Select the cell containing the formula.

2. Position the mouse on the bottom right of the highlighted border of the cell, and continue

holding down the mouse button until the pointer changes to a cross-hair symbol.

3. With the mouse button pressed, drag it down or to the right over all the cells into which

the formula will be copied.

4. Upon releasing the mouse button, the formula will be copied into the cells and

automatically adjusted.

Where values and texts must not be automatically adjusted, then hold down the Ctrl key

when dragging. formulae, however, are always adjusted accordingly when dragging.

Now look at what happened when rows and columns are added. Assume a calculation in cell

E1 that sums the cells in range A1:B2. The formula to enter into E1 would be:

=SUM(A1:B2). If, later, a new column must be in front of column A, the elements to be

added would then be in B1:C2 and the formula would be in F1, not in E1. After inserting

the new column, all formulae would therefore have to be checked and corrected in the current

sheet, and possibly in other sheets.

Fortunately, Calc does this work automatically. After inserting a new column A, the formula

=SUM(A1:B2) is updated to =SUM(B1:C2). Row numbers are also automatically adjusted

when a new row is inserted. Absolute and relative references are always adjusted in Calc.

OpenOffice.org User Guide for 2.x 228

1 2 ... 257 258 259 260 261 262 263 264 265 266 267 ... 507 508

Sin comentarios

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