OpenOffice.org OpenOffice - 3.0 User Manual download pdf (Page 318)

100

101

Tip

To display the list of the mathematical functions that you can use

in a table:

1) Display the Formula toolbar by pressing

or by selecting a

blank cell and pressing the

key.

2) Click and hold the Formula f(x) icon.

In our example, this gives the result 9 in the top left cell. For

contiguous cells, you can simply select the cells in the row, column, or

the rectangle of rows and columns. Thus, for example, to add a column

of numbers, do this:

1) Type an equals sign = in an empty cell.

2) Select the cells to be added together—in this case the cells from

A2 to A5. The formula should be something like =<A2:A5>.

3) Press the

Enter

key or click the green tick (checkmark) on the

Formula Bar.

4) The answer appears in the cell you have selected.

When using a function, you can enter the cells manually or by selecting

them. Thus, to add up the four numbers that we added above (A2, A3,

A4, A5), do this:

1) Type an equals sign

in an empty cell.

2) Type sum or select it from the function list f(x).

3) Select the cells to be added together. The formula should be

something like =sum<A2:A5>.

4) Press the

Enter

key or click the green tick (checkmark) on the

Formula Bar.

5) The answer appears in the cell you have selected.

Caution

Unlike Calc, when inserting or deleting rows or columns of the

table, formulas are not updated automatically. If you plan to use

complex formulas you should consider embedding a Calc

spreadsheet in your Writer document.

Additional table operations

Adding a caption

You can easily add a caption to any table. Writer will keep track of all

your captioned tables, automatically number them, and update any

links to them.

318 OpenOffice.org 3 Writer Guide

1 2 ... 313 314 315 316 317 318 319 320 321 322 323 ... 547 548

Comments to this Manuals

No comments

OpenOffice.org OpenOffice - 3.0 User Manual Page 318

Comments to this Manuals

Related products and manuals for Software manuals OpenOffice.org OpenOffice - 3.0