
Chapter 3: Managing Text Documents With Writer
Calculating Cell Totals in Tables
1. Insert a table with multiple rows (Insert > Table) into a new text document.
2. Enter a series of numbers into a column, one number per row, leaving the last cell of the
column empty.
3. Place the cursor in the last empty cell of the column.
4. Click the Sum icon in the Table object bar.
5. The Formula bar appears, and a formula indicates the cells of the column to be added. The
cells are separated by a vertical bar (|).
6. Press the Enter key to confirm, or click Apply in the Formula bar. The sum will appear
in the last cell.
When numbers are changed in the table, the sum is automatically be updated. If, for example,
formatting the numbers as currency, select the cells and choose Number Format from the
context menu. The Number Format dialogue appears, where the user can choose a new
format.
Merging and Splitting Cells
One can select adjacent cells together, then merge them into a single cell. Conversely, a large
cell that has been created by merging single cells can be divided back into individual cells.
The commands are different in OpenOffice.org Writer and Calc.
Merging Cells in OpenOffice.org Writer
1. Highlight all the cells to be included in the merged cell.
2. Select Table > Merge Cells.
Splitting Cells in OpenOffice.org Writer
1. Set the cursor in the cell to be split.
2. Select Table > Split Cells.
A dialogue allows splitting the cell into two or more cells, horizontally or vertically.
Merging Cells in OpenOffice.org Calc OLE Objects
1. Highlight all the cells to be included in the merged cell.
2. Select Format > Merge Cells. The state of this menu item is toggled on. Note that this
menu item reflects the state of the current selected cell.
Cancelling the merging of cells in OpenOffice.org Calc OLE Objects
1. Set the cursor in the cell to be split.
2. Select Format > Merge Cells. The state of this menu item is toggled off.
OpenOffice.org User Guide for 2.x 152
Comentarios a estos manuales