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

Chapter 9: Advanced Techniques

Drag and Drop With the Data Source View

The simplest and quickest way of transferring data from a data source into a text or

spreadsheet document, or creating forms based on a data source, is the drag-and-drop

method.

Copying with Drag&Drop

To reverse a mistake made during a drag and drop operation, position the cursor in the

document and choose the Undo command from the Edit menu (or via the keyboard).

Note: Copying by drag and drop is possible in the both directions:

6. A text table or a selected range of a spreadsheet can be dragged using drag and drop to a table container in the

data source explorer or vice versa.

7. Likewise, simpler text can be copied using drag and drop from one document to a data field in the data source

view. Read up on how this happens in Help.

Using data in a text document

A database field can be inserted in a text document by dragging a field name from the

column header of the data source view into the document. This inserts a field for this

database field in the document. This is especially useful when designing form letters. Simply

drag the desired fields, such as, home address, form of address et cetera, into the document.

The best way to insert a complete record is to select the corresponding header and drag it into

the document. When the mouse button is released, the Insert database columns dialogue

appears, where one can decide whether to use all database fields, and whether to copy the

data into the document as text, a table or fields. All currently selected records will be

inserted.

Applying data to a table document

One or more records can be inserted into the current sheet of a spreadsheet by selecting the

rows in the data source view and dragging and dropping them into the spreadsheet. The data

is inserted in the place where the mouse button is released.

Inserting controls in a text form

When a text form, linked to a database, is created, one can generate controls by drag-and-

drop from the data source view: When a database column is dragged into the text document,

a field is inserted. By holding down Shift+Ctrl while dragging, a text field is inserted,

grouped with an appropriate label field. The text field already contains all the database

information that is needed for the form.

OpenOffice.org User Guide for 2.x 404

1 2 ... 433 434 435 436 437 438 439 440 441 442 443 ... 507 508

Keine Kommentare

OpenOffice.org 2.x Betriebsanweisung Seite 438