Embedding Spreadsheets

Apache OpenOffice 4.1 Calc Guide

Chapter 10: Linking Calc Data

< Previous Section

Next Section >

• Why Use Multiple Sheets?
• Setting Up Multiple Sheets
  • Identifying Sheets
  • Renaming Sheets
  • Inserting New Sheets
  • Inserting Sheets From a Different Spreadsheet
• Referencing Other Sheets in the Spreadsheet
  • Creating the Reference with the Mouse
  • Creating the Reference with the Keyboard
• Referencing Other Documents: Links to Sheets in Other Spreadsheets
  • Creating the Reference Using the Mouse
  • Creating the Reference with the Keyboard
• Hyperlinks and URLs
  • Relative and Absolute Hyperlinks
  • Creating Hyperlinks
  • Editing Hyperlinks
  • Removing Hyperlinks
• Linking to External Data
  • Using the External Data Dialog
  • Using the Navigator
  • How to Find the Required Data Range or Table
• Linking to Registered Data Sources
  • Viewing Data Sources
  • Editing Data Sources
  • Launching Base to Work on Data Sources
  • Using Data Sources in Calc Spreadsheets
• Embedding Spreadsheets
  • Object Linking and Embedding (OLE)
    • Other OLE Objects
    • Non-linked OLE Object
    • Linked OLE Object
  • Dynamic Data Exchange (DDE)
    • DDE Link in Calc
    • DDE Link in Writer

< Previous Page

Next Page >

Embedding Spreadsheets

Spreadsheets can be embedded in other OpenOffice files. This is often used in Writer or Impress documents so Calc data can form part of a text document. You can embed the spreadsheet as either an OLE or DDE object. The difference between a DDE object and a Linked OLE object is that a Linked OLE object can be edited from the document in which it is added as a link, but a DDE object cannot. The rest of this chapter discusses the nature of OLE and DDE links.

For example, if a Calc spreadsheet is pasted into a Writer document as a DDE object, the spreadsheet cannot be edited in the Writer document. However, if the original Calc spreadsheet is updated, the changes are automatically made in the Writer document. If the spreadsheet is inserted as a Linked OLE object into the Writer document, then the spreadsheet can be edited in the Writer and in the Calc document, and both documents will remain in sync.