OpenOffice.org OpenOffice - 3.0 User's Guide download pdf (Page 159)

You can

move

the spreadsheet (change its position within the slide)

whether in edit mode or not. In both cases:

1) Move the mouse over the border until the cursor changes shape.

2) Click and hold the left mouse button and drag the spreadsheet to

the desired position.

3) Release the mouse button.

When selected but not in edit mode (green handles), the spreadsheet

object is treated like any other object, therefore resizing it results in

changing the scale rather than the spreadsheet area. This is not

recommended, because it may distort the fonts and picture shapes.

Moving around the spreadsheet

How a spreadsheet is organized

A spreadsheet consists normally of multiple tables which in turn

contain cells. However, in Impress only one of these tables can be

shown at any given time on a slide.

The default for a spreadsheet embedded in Impress is one single table

called

Sheet 1

. The name of the table is shown at the bottom of the

spreadsheet area (see Figure 116).

If required, you can add other sheets. To do that:

1) Right-click on the bottom area near the existing tab.

2) Select Insert > Sheet from the pop-up menu.

Just like in Calc, you can rename a sheet or move it to a different

position using the same pop-up menu or the Insert menu on the main

menu bar.

Note

Even if you have many sheets in your embedded spreadsheet,

only one sheet—the one which is active when leaving the

spreadsheet edit mode—is shown on the slide.

Each of the sheets is further organized into

cells

. Cells are the

elementary unit of the spreadsheet. They are identified by a row

number (shown on the left hand side on gray background) and a

column letter (shown in the upper part again on gray background). For

example, the top left cell is identified as A1, while the third cell in the

second row is C2. All data, whether text or numbers, is input in a cell.

Chapter 7 Inserting Spreadsheets, Charts, and Other Objects 159

1 2 ... 154 155 156 157 158 159 160 161 162 163 164 ... 274 275

No comments

OpenOffice.org OpenOffice - 3.0 User's Guide Page 159