OpenOffice.org video based manual
Plan-B for OpenOffice.org, learning office productivity software with videos


Tech Support for OpenOffice.org
Applications
Go to Open Office Writer Index
Go to Open Office Impress Index
Go to Open Office Math Index
Go to Open Office Draw Index
Go to Open Office Calc Index
Go to Open Office Base Index
Go to Open Office Online Help Index

Help Sections:
General
Writer
Impress
Math
Draw
Calc
Base
Basic

Including Spreadsheets in Slides

Inserting a new OpenOffice.org Calc spreadsheet

You can add a blank OpenOffice.org Calc spreadsheet to a slide as an OLE object.

  1. Go to the slide where you want to insert the spreadsheet.

  2. Do one of the following:

    Choose Insert - Spreadsheet. Click in the spreadsheet to enter your data.

    Open the Layouts task pane, and double-click the Title, Spreadsheet layout. In the slide, double-click the placeholder for the spreadsheet, and then click in the spreadsheet to enter your data.

  3. Click outside the spreadsheet to view the slide.

To resize the spreadsheet without resizing the cells, double-click the spreadsheet, and then drag a corner handle. To resize the cells of the spreadsheet, click the spreadsheet, and then drag a corner handle.

Inserting OpenOffice.org Calc spreadsheets from a file

When you insert an existing spreadsheet into your slide, changes that are made to the original spreadsheet file are not updated on your slide. You can, however, make changes to the spreadsheet in your slide.

  1. Go to the slide where you want to insert the spreadsheet.

  2. Choose Insert - Object - OLE Object.

  3. Select Create from file, and click Search.

  4. Locate the file you want to insert, and then click OK.

The entire spreadsheet is inserted into your slide. If you want to change the sheet that is displayed, double-click the spreadsheet, and then select a different sheet.

Format - Slide Layout

Insert - Object - OLE Object

Index

spreadsheets,in presentations

presentations,inserting spreadsheets

including spreadsheets

This help text is published from the OpenOffice-Help files under the Public Documentation License 1.0.

Get OpenOffice.org - Free!