Le 05/10/2012 23:45, robertjm a écrit :
Hi Robert,
While I understand how to insert the name and ages text from a Calc
spreadsheet, I'm not clear on how to automate the photo insert.
Is it as simple as adding a URL link into a cell within Calc (i.e.:
"John","Smith","c:\files\JohnSmith.jpg") and then add a pointer to that data
within the Text document?
No that won't work on its own because you're attempting to define a
secondary data source (i.e. for the images) "by reference" to the
underlying file system and LO doesn't know how to process that kind of
information, which in essence is saying something like : "take this
character string, consider it to be a file, open the file and parse
(stream) its contents so that it gets interpreted and displayed as an
image".
At the moment, the only way to directly display images from a datasource
are through Forms or Reports, and these are not tied into the mailmerge
capabilities, otherwise you need a macro to do the lifting work for you.
Below are links to information on the subject :
http://forum.openoffice.org/en/forum/viewtopic.php?f=7&t=31109
http://forum.openoffice.org/en/forum/viewtopic.php?f=7&t=33396
http://www.oooforum.org/forum/viewtopic.phtml?t=89804
http://www.oooforum.org/forum/viewtopic.phtml?t=73329
And the following extension, which seems to be almost identical to what
you want :
http://extensions.services.openoffice.org/fr/project/text2pic
As you will no doubt understand after having read the various posts, a
request for this functionality, i.e. being able to mailmerge image files
and have them display and print properly in a merged document is a
feature that has been requested since at least 2003, for OpenOffice.org,
and was never implemented.
https://issues.apache.org/ooo/show_bug.cgi?id=18651
Alex
--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/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.