Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


Hi Joe,

On 28/03/11 19:39, Joe Nierenberg wrote:
I would like to include text from a closed file into the open file. However, rather than have all of the text there, reproduced in the open file, I want only the field name. (The reason is that it is conditional text, that might not always be included.) According to my searches, there is no LO Writer equivalent to MS Word's INCLUDETEXT field; there is only the menu command to insert a file, which gives the entire text. Ideas?

I /might/ have found an answer for this. The answer came from finding out what DDE actually stands for. From the Writer help:


   "DDE

DDE stands for "Dynamic Data Exchange," which is a predecessor of OLE, "Object Linking and Embedding". With DDE, objects are linked through file reference, but not embedded.

You can create a DDE link using the following procedure: Select cells from a Calc spreadsheet, copy them into the clipboard and switch to another spreadsheet and select the *Edit - Paste Special* dialogue box. Select *the Link* option to insert the contents as a DDE link. When activating a link, the inserted cell area will be read from its original file."


I did this, copying a footnote field from one document and paste-special-ing it into another (Ctrl-Shift-v). While editing, the pasted field seems to contain only the text "DDE field" but a print preview shows that it contains the proper value.

In order to get the fields to update you have to go Tools > Update > Links rather than Tools > Update > Fields, so F9 doesn't do it (under the default config). Also, links sometimes appear to become disconnected (right-click > Fields...: 'Status' column for link no longer says 'Automatic'). I haven't been able to work out when / why exactly this happens.

I haven't tried this with conditional fields. I would be very interested to know if this solves your problem.

Cheers,

-r

--
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.