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

Chapter 3: Managing Text Documents With Writer

Calculating in Text Document Tables

OpenOffice.org Writer tables can also include calculations, and these can extend between

tables.

For example, there are two tables, labelled Table1 and Table2 in which the first cell of

Table1 must be multiplied by the first cell of Table2 and the product returned in cell A2

of the current table. In this case, the table names serve as table identifiers.

Here's how:

1. Enter numbers into cells A1 of Table1 and A1 of Table2.

2. Position the cursor in cell A2 of Table2.

3. Press F2 to bring up the Formula bar. It already starts with an '=' ready for the user to type

a formula.

4. Click on cell A1 of Table1. OpenOffice.org will insert the cell reference

<Table1.A1> into the formula bar.

5. The formula bar is still waiting for the user to continue entering the formula, so now type

* (the multiply operator).

6. Click on cell A1 in Table2. OpenOffice.org will insert the cell reference <A1> into the

formula bar with no user action. Note that this time the reference does not need the table

identifier.

7. Press Enter now to complete the formula and the product is presented in Table2 cell A2.

1. Note: With the help of the Navigation Bar one can navigate quickly and easily between

the table formulae in the document.

If a table formula refers to an invalid table cell, a “**Faulty expression**” is displayed in the cell. Invalid table

cells are either deleted cells or those which are themselves faulty.

It is only possible to refer to table cell values from within tables. One trick to inserting a table

calculation result within text is demonstrated by this next example.

To add cells B1:B 10 from Table1 and present the sum in a line of text, :

Create the text and Table1.

1. Place the cursor in the text where the sum is to appear.

2. Insert a frame (Insert > Frame menu command). In the Frame dialogue select the

Anchor as As Character.

a) Deselect the border.

b) Click OK to close the dialogue.

1. Deselect the frame by clicking outside it.

Note: when entering text in the frame, click in the very centre of the frame. The frame should not be selected, but

the text cursor should be inside the frame.

OpenOffice.org User Guide for 2.x 150

1 2 ... 179 180 181 182 183 184 185 186 187 188 189 ... 507 508

Sin comentarios

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