OpenOffice.org OpenOffice - 3.0 Quick Start Guide download pdf (Page 284)

5) Select the settings for your table. Use the default settings as in

Figure 236.

6) Click OK.

7) Save the document.

Calc spreadsheets

There are two ways to enter data in a Calc spreadsheet. One enters the

data into the spreadsheet cells. The other creates records in the

spreadsheet just like they are done in creating a form in a database.

While you can directly access the data in the spreadsheet cells, you can

only see the data in the records created in the spreadsheet.

Entering data directly to the spreadsheet cells uses the

Data to Text

icon as we did to make a table in a Writer document. But differences

exist in these two situations.

The steps are straightforward.

1) Click the cell of the spreadsheet which you want to be the top left

of your data including the column names.

2) Use F4 to open the database source window and select the table

whose data you want to use.

3) Select the rows of data you want to add to the spreadsheet:

• Click the gray box to the left of the row you want to select if

only selecting one row. That row is highlighted.

• To select multiple rows, hold down the

shift

key while clicking

the gray box of the rows you need. Those rows are

highlighted.

• To select all the rows, click the gray box in the upper left

corner. All rows are highlighted.

4) Click the

Data to text

icon to insert the data into the spreadsheet

cells.

5) Save the spreadsheet.

Adding records to a spreadsheet is fairly easy. You need to have the

ata Source

window open, your spreadsheet open, and the table you

want to use selected.

1) Click the gray box above the field name you wish to use to

highlight it.

2) Drop and drag the gray box to where you want the record to

appear in the spreadsheet.

3) Repeat until you have moved all of the fields you need to where

you want them.

284 Getting Started with OpenOffice.org 3

1 2 ... 279 280 281 282 283 284 285 286 287 288 289 ... 432 433

Comments to this Manuals

No comments

OpenOffice.org OpenOffice - 3.0 Quick Start Guide Page 284

Comments to this Manuals

Related products and manuals for Graphics software OpenOffice.org OpenOffice - 3.0