Re: Re: [libreoffice-users] INCLUDETEXT

Ryan,

First of all, thanks for persisting with this.

Unfortunately, the solution does not seem to work.

(Even if it worked, it would be a little kludgy, because a user would 
have to first go to the source document to copy.  If the target is a 
template, that wouldn't be too difficult, but it's not the same as 
browsing and clicking.)

Source document = where the text I want to include resides
Target document = where I want the included text to appear

When I copied the text of the source document and special pasted it into 
the target document, doing so as a LO Writer object inserted the whole 
text.  But doing so as a DDE object, which is what you suggested, 
does... nothing.  Nothing appears in editing mode, nor in page preview 
mode.  (I didn't look at the XML, because if the functionality isn't 
there, I don't really care what's under the hood.)  Special pasting the 
DDE link onto an existing piece of text in the target document deletes 
the pre-existing text but replaces it with nothing.

I played around with inserting sections, both as links and as links/DDE, 
but that didn't seem to work, either.

Joe


On 1:59 PM, Ryan Jendoubi wrote:
> 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




--

Joe Nierenberg


    Nierenberg Employment Law, P.L.L.C.
    Consulting – Litigating – Training
    Tel. 952-826-6494
    www.nierenberg.com

--
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