OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido descargar pdf (Pagina 289)

You can also limit the fields you use to less than all of the

fields available.

• If you want to use all of the fields, use the double arrow

pointing to the right to move all of them at one time. The

order of the fields in the table you create will be the same as

in the data source table.

• To remove a single field from the Table Column(s) list, click

the field and use the single arrow pointing to the left.

• To start over, click the double arrow pointing to the left.

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

Figure 222.

6) Click OK. 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 Control 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.

Chapter 8 Getting Started with Base 289

Free eBook Edition

1 2 ... 284 285 286 287 288 289 290 291 292 293 294 ... 441 442

Sin comentarios

OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido Pagina 289