OpenOffice.org OpenOffice - 3.3 Podręcznik Użytkownika Pobierz pdf (Strona 144)

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

130).

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 as 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 units of

the spreadsheet. They are identified by a row number (shown on the left hand side on

a gray background) and a column letter (shown in the top row also on a gray

background). For example, the top left cell is identified as A1, while the third cell in

the second row is C2. All data elements, whether text, numbers or formulas, are

entered into a cell.

Moving the cursor to a cell

To move around the spreadsheet and select an active cell, you can:

• Use the arrow keys.

• Left-click with the mouse on the desired cell.

• Use the combinations Enter and Shift+Enter to move one cell down or one cell

up respectively; Tab key and Shift+Tab key to move one cell to the right or to

the left respectively.

Other keyboard shortcuts are available to move quickly to certain cells of the

spreadsheet. Refer to Chapter 5 (Getting Started with Calc) in the Getting Started

guide for further information.

Entering data

Keyboard input is received by the active cell, identified by a thick black border (see

Figure 130 where cell A1 is active). The cell reference (or coordinates) is also shown

on the left hand end of the formula bar.

To insert data, first select the cell to make it active, then start typing . Note that the

input is also added to the main part of the formula bar where it may be easier to

read.

Impress will try to automatically recognize the type of contents (text, number, date,

time, and so on) of a cell and apply default formatting to it. Note how the formula bar

icons change according to the type of input, displaying Accept and Reject buttons (

) whenever the input is not a formula. Use the green Accept button to confirm

the input made in a cell or simply select a different cell. In case Impress wrongly

recognizes the type of input, you can change it using the toolbar shown in Figure

131, or from Format > Cells in the main menu bar.

Chapter 7 Including Spreadsheets, Charts, and Other Objects 149

1 2 ... 139 140 141 142 143 144 145 146 147 148 149 ... 247 248

Komentarze do niniejszej Instrukcji

Brak uwag

OpenOffice.org OpenOffice - 3.3 Podręcznik Użytkownika Strona 144

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Oprogramowanie OpenOffice.org OpenOffice - 3.3