OpenOffice.org 2.x Guía de usuario descargar pdf (Pagina 439)

Chapter 9: Advanced Techniques

Copying Sheet Areas to Text Documents

• Open both the text document and the spreadsheet.

• Select the sheet area to copy.

• Point to the selected area and press the mouse button. Keep the mouse button pressed for a

moment, then drag the area into the text document.

If the documents are not visible next to each other, first drag the mouse pointer to the

destination document button. Continue to hold down the mouse button. The document

addressed in this way is displayed, and the mouse pointer can be moved within the

document.

• Once the cursor is located in the place where to insert the sheet area, release the mouse

button. The sheet area is inserted as an OLE object.

Select and edit this OLE object at any time.

11.To edit the OLE object, simply double-click on it.

Alternatively, select the object and choose Edit > Object > Edit or choose Edit from the

context menu. The object can be edited in its own frame within the text document, but the

icons and menu commands needed for spreadsheets are visible.

12.Choose Open to open the source document of the OLE object.

Inserting Data From Spreadsheets

• When copying the contents of a cell (text or numbers), using the clipboard is best.

Copying formulae that are in the cells into the clipboard, such as from the input lines of

the formula bar, is also possible; thus. they can now be inserted into the text.

• To copy a simple, rectangular area of cells into a text document as a sheet, select the cells

in the sheet and then use either the clipboard or drag & drop to insert them into the text

document. This will be an OLE object in the text document that can edited.

• If cells are dragged to the character view of a presentation document, they will also re-

appear there as OLE objects. Once dragged into the outline view, each cell will form a line

of the outline view. Dragging using drag-and-drop will move the cells. Press the Shift

key, when dragging, create a copy.

Inserting Data From Text Documents

Text can be transferred into other document types such as spreadsheets and presentations but,

there is a distinction made that depends on whether the text should be set in its own text

frame, transferred into a spreadsheet cell or transferred into the structure of a presentation.

• If text is transferred via the clipboard, one can paste it to the destination with or without

text attributes. Use the shortcut keys Ctrl+C to copy and Ctrl+V to paste.

To select the format in which the clipboard contents will be pasted, do a long click on the

Paste icon on the Standard toolbar. Select the format from the submenu.

• To obtain a selection of formats, choose Edit > Paste Special.

OpenOffice.org User Guide for 2.x 405

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

Sin comentarios

OpenOffice.org 2.x Guía de usuario Pagina 439