OpenOffice.org 2.x Betriebsanweisung PDF herunterladen (Seite 282)

100

101

Chapter 4: Spreadsheets in Calc

6. Select the folder containing the database file(s) in *.dbf format.

7. Click OK.

8. In the Name field, enter a name to be displayed for the data source.

9. Click Apply.

10.Click the Tables tab. Put a check mark next to the names of the table(s) needed in the data

source view.

11.Click OK.

12.Open the data source browser (F4).

13.Click on the plus (+) sign next to Tables to view the existing tables in the database.

14.In a dBase database, each *.dbf file in the directory is a table of its own.

15.Click the name of the table. The records are displayed in the data source browser.

Select the records and insert them into the spreadsheet.

1. To manually select a record(s) for transfer into the spreadsheet, click the row header of the

record (the gray field without text at top left). Click the first and last record row headers of

a continuous range of records while pressing the Shift key to select the range, or hold

down the Ctrl key and click the desired records individually.

2. Drag the selected records to the row headers in the sheet where the records are to be

inserted. Then release the mouse button.

To automatically transfer only specific records from a large database into the spreadsheet, use

the filters in the data source browser:

1. Set the cursor in the data field which contains the data (should be the same in all filtered

records). For example, to filter only records that have Main Street in their address,

place the cursor in a field containing Main Street.

2. Click the AutoFilter icon.

3. Now only the records containing the precise text, Main Street, are visible.

4. Select the Main Street records. For example, using the Shift key as described

above, drag the selected records into the spreadsheet document and release the mouse

button at the point where the first field should be inserted.

OpenOffice.org User Guide for 2.x 248

1 2 ... 277 278 279 280 281 282 283 284 285 286 287 ... 507 508

Kommentare zu diesen Handbüchern

Keine Kommentare

OpenOffice.org 2.x Betriebsanweisung Seite 282

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software-Handbücher OpenOffice.org 2.x