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

Chapter 4: Spreadsheets in Calc

The automatic formula recognition allows entering, for example, the formula =SUM(Ju ly)

in cell B8. This formula can then be copied to the right. Cell C8 automatically shows the

formula =SUM(August), cell D8 =SUM(September), and so on. This feature also works

for horizontal calculations. Try it out by entering the formula =SUM(London) in cell E4.

The New York entry must be treated as a special case because this name contains a space.

Thus, it must be enclosed in single quotation marks: =SUM('New York').

Automatic recognition does not work with formulae. One cannot enter the formula

=SUM(sum) in cell E8. Instead, enter =SUM(B8:D8) or =SUM(E3:E6). The latter

formula will also be inserted automatically if the cursor is placed in cell E8 and the Sum icon

in the Formula bar is clicked.

This function is active by default. To turn it off, select Tools - Options... > Spreadsheet

Document > Calculate and uncheck the box in front of Automatically find column and

row labels.

Use Insert > Names > Labels.... to define any names required as shown in the previous

section.

Note: To have names automatically recognized, names must consist of alphanumeric characters and the first

character must be a letter. To use non alphanumeric characters (including spaces), enclose the names in single

quotation marks

(')

. Where a single quotation mark appears in a name, e.g., Jan '97, enter a backslash in front of

the quotation mark (Jan \'97). This type of referencing is not compatible with earlier versions of OpenOffice.org.

Calc automatically recognizes an area, called a range, of cells that belong together. To

determine which cells make up a particular range, place the cell cursor in the desired range

and press Ctrl + * but remember to use only the * from the numerical key pad as

Ctrl+ Shift +8 (the asterisk over the 8) does not work. The range will be highlighted.

Only Copy Visible Cells

Assume the user has hidden are a few rows or columns in a cell range and now only the

visible cells are to be copied.

Calc behaves differently depending on the method used to hide the invisible cells and what is

the intended action to be performed upon them.

Method Result

Cells were filtered out by way of AutoFilters, default

filters or special filters.

Only the visible cells are copied.

OpenOffice.org User Guide for 2.x 230

1 2 ... 259 260 261 262 263 264 265 266 267 268 269 ... 507 508

Sin comentarios

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