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

Chapter 3: Managing Text Documents With Writer

c) Insert a single-cell table inside the frame using Insert > Table.

d) Set a row and a column value of 1, uncheck Heading, and uncheck Border.

e) Click OK.

f) The cursor is positioned in Table2.

b) Define the formula by either pressing F2 or typing an equal sign (=) into the cell (this is a

short-cut), at which point the Formula bar will be displayed.

The formula for calculating the total of cells B1 to B10 is: “ = <Table1.B1:B10> ”.

But don't type this yet because there is a simpler way.

5. Highlight the cells in Table1 to be summed. Do this by keeping the mouse button

pressed as the pointer is dragged from the first to the last cell being summed.

6. Close the mathematical formula by clicking the Accept icon on the Calculation Bar. The

result of the calculation will be seen in Table2.

7. If there are changes in the cells being summed, update the result by pressing function key

(F9).

Note: Instead of first inserting the border and then inserting a table inside the border, start by inserting a single-

cell table, then select the whole of this cell - the only way to do this is with the shortcut keys

(Ctrl+a)

and then

click on the Insert > Frame icon. The border automatically surrounds the table (incidentally, this also works with

any section of text). Now set the anchor to character, cut the whole table to the clipboard and paste it where it

should go, remove the borders from the frame and table and apply further settings.

Calculating Across Multiple Tables

Calculations in any text document, where there are more than one table which contains data

required for calculation, can be done in OpenOffice.org Writer. For example:

• Insert two tables each with several rows and columns.

1. Enter a few figures in the tables, but leave at least one cell empty.

The tables should be automatically named “Table1” and “Table2”. If one chooses, each

table can be given a different name (Table > Properties, Table tab, text box Name) using

only letters and numbers for naming.

1. Position the cursor in an empty cell.

2. Press F2 to display the Formula bar.

3. As an example, enter SUM.

4. Individually click the cells containing figures in both tables that are part of the calculation.

After each click, enter a plus sign (+) from the keyboard, and continue to the next cell

containing a figure.

5. Finally, click the Apply icon on the Formula Bar. For example, if adding up the first two

rows of each table and showing the total in Table2, the formula is

=sum<Table 1.A1>+<A1>.

OpenOffice.org User Guide for 2.x 151

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

Sin comentarios

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