How to Insert DDE Links in LibreOffice Writer

Dynamic Data Exchange (DDE) allows LibreOffice Writer to display and automatically update data pulled directly from external sources, such as a LibreOffice Calc spreadsheet. This guide provides a straightforward walkthrough on how to insert and manage DDE links in LibreOffice Writer using both the quick Paste Special method and the manual field insertion method.

Method 1: Using Paste Special (Recommended)

The easiest way to insert a DDE link is by copying the source data and pasting it as a link.

1. Open the Source File: Open the LibreOffice Calc spreadsheet containing the data you want to link.
2. Copy the Data: Select the cell or range of cells, right-click, and choose Copy (or press Ctrl + C).
3. Open LibreOffice Writer: Navigate to your Writer document and place the cursor where you want the linked data to appear.
4. Paste Special: Go to the top menu and select Edit > Paste Special > Paste Special… (or press Ctrl + Shift + Alt + V).
5. Select DDE Link: In the dialog box that appears, select DDE link from the list and click OK.

The copied data will appear in your Writer document. Any changes saved in the source spreadsheet will now automatically reflect in your Writer document.

Method 2: Inserting a DDE Field Manually

If you know the syntax or need to configure the link manually, you can insert a DDE field directly.

1. Position the Cursor: Click inside your Writer document where you want the DDE link to go.
2. Open the Fields Menu: Go to Insert > Field > More Fields… (or press Ctrl + F2).
3. Select the DDE Type:
   • Click on the Variables tab at the top.
   • Under Type, select DDE command.
4. Configure the DDE Command:

   • Name: Enter a descriptive label for the link.

   • DDE Command: Fill in the external reference using the format:

     soffice <Path_to_File> <SheetName.CellReference>

     Example: soffice C:\Users\Username\Documents\Data.ods Sheet1.A1

   • Format: Choose whether the output should be treated as text or numbers.

5. Insert: Click Insert, then click Close.

How to Update or Modify DDE Links

To manage existing DDE links in LibreOffice Writer:

• Manual Update: Go to Tools > Update > Links to refresh all linked data immediately.
• Edit Link Paths: Go to Edit > Links to External Files… to view all active DDE connections, modify file paths, or break links to turn the data into static text.