Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




OpenOffice Calc 3.x Guide
Previous Page Home Next Page

Object Linking and Embedding (OLE)

The major benefit of an OLE (Object Linking and Embedding) object is that it is quick and easy to edit the contents just by double-clicking on it. You can also insert a link to the object that will appear as an icon rather than an area showing the contents itself.

OLE objects can be linked to a target document or be embedded in the target document. Embedding inserts a copy of the object and details of the source program in the target document. If you want to edit the embedded spreadsheet, double-click on the object.

To add an OLE object:

  1. Place the cursor in the document and location you want the OLE object to be.
  2. Select Insert > Object > OLE Object. The dialog shown below opens.
  3. You can either create a new OLE object or create from a file.
Insert OLE object dialog

To create a new object:

  1. Select Create new and select the object type among the available options.
  2. Image:documentation_note.png “Further objects” is only available under a Windows operating system. It does not appear in the list under any other system.
  3. Click OK. An empty container is placed in the spreadsheet.
  4. Double-click on the OLE object to enter the edit mode of the object. The application devoted to handling that type of file will open the object.
  5. Image:documentation_note.png If the object inserted is handled by, then the transition to the program to manipulate the object will be seamless; in other cases the object opens in a new window and an option in the File menu becomes available to update the object you inserted.

To insert an existing object:

  1. To create from a file, select Create from file. The dialog box changes to look like the example below.
  2. To insert the object as a link, select the Link to file option. Otherwise, the object will be embedded.
  3. Click Search, select the required file in the file picker window, then click Open. A section of the inserted file is shown in the document.
Inserting an object as a link

Other OLE objects

Under Windows, the Insert OLE Object dialog box has an extra entry, Further objects.

  1. Double-click on the entry Further objects to open the dialog shown below.
  2. Advanced dialog to insert an OLE object under Windows
  3. Select Create New to insert a new object of the type selected in the Object Type list, or select Create from File to create a new object from a file.
  4. If you choose Create from File, the dialog shown below opens. Click Browse and choose the file to insert. The inserted file object is editable by the Windows program that created it.
  5. Insert object from a file

If instead of inserting an object, you want to insert a link to an object, select the Display As Icon option.

Non-linked OLE object

If the OLE object is not linked, it can be edited in the new document. For instance, if you insert a spreadsheet into a Writer document, you can essentially treat it as a Writer table (with a little more power). To edit it, double-click on it.

Linked OLE object

When the spreadsheet OLE object is linked, if you change it in Writer it will change in Calc; if you change it in Calc, it will change in Writer. This can be a very powerful tool if you create reports in Writer using Calc data, and want to make a quick change without opening Calc.

Image:documentation_note.png You can only edit one copy of a spreadsheet at t a time. If you have a linked OLE spreadsheet object in an open Writer document and then open the same spreadsheet in Calc, the Calc spreadsheet will be a read-only copy.

OpenOffice Calc 3.x Guide
Previous Page Home Next Page

  Published under the terms of the Creative Commons License Design by Interspire