LibreOffice add external data field to document

You may want to use some external variables that are shared between several of your Writer documents.

One way to do that would be to use Mail Merge, but that may not be what you prefer.

Another solution is to insert the data you want as DDE link to the source document.

Let’s say you have a string in your Calc spreadsheet and you want it to show up in your Writer document:

  • Open the Calc spreadsheet
  • Copy the cell
  • Open the Writer document
  • Select menu Edit -> Paste Special -> DDE Link
  • Press Ctrl+Z
  • Press Ctrl+F
  • Select Variable tab
  • Select Type: DDE Field
  • Select the name of variable in Select control
  • Click Insert button

The method is a bit clumsy, but it works just fine. Possibly you may stop after pasting the DDE link, which gives you a fragment of a table, depends upon what do you need.

To see field values instead of field codes:

  • Select menu View -> Field Names (or press Ctrl+F9)

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s