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


The way I approach this is to "mail merge" the information into a template
document. "Mail merge" is missnamed.. it's really a data query.

This isn't a process that can be well-described in a mail message in
this thread. You'll need to watch videos about it or get a book that covers
it.

But I use this type information to build book covers, including up to 7
paragraph back cover copy taking up ~5000 characters. each cell's column
has a label, each label becomes a token that can be treated as an inline
text object, which then gets merged (replaced) with the contects of  the
row of the spreadsheet.


On Sat, Apr 29, 2023 at 5:46 AM Mike Flannigan <mflan@mflan.com> wrote:


I suggest you use the concatenate command, perhaps multiple
times with If commands included where needed to get the
A-L columns combined into a single cell in the output
format you desire.



Mike



On 4/27/23 03:04, users+help@global.libreoffice.org wrote:
Subject:
[libreoffice-users] Importing a row from a spreadsheet
From:
Ian Graham <idgraham@btinternet.com>
Date:
4/26/23, 05:47

To:
users@global.libreoffice.org


Good morning from Wales, UK


I am a member of a local Heritage Society which some years ago created a
digital archive of several hundred photographs.

The archive is indexed in an Excel-type document, which was possibly not
very skilfully formated at the time. The index comprises 12 columns,
A>L, in an A4 Landscape layout, but the actual document seems to extend
rightwards almost to infinity.

I would now like to create new individual ‘slides’, probably as pdfs,
uniting each image with the information about it. But I have not yet
worked out the best method by which to import the information from the
*.ods.


One difficulty is that a ‘copy’ of a row from the dbase does not paste
neatly into a new document – it always seems to spill out to the right.

The other difficulty is choosing the best method of pasting. I have
tried all the ‘paste special’ options, and none of them seem to offer a
one-stop-shop route of import.


I have tried, for instance, creating a new table of 12 equal columns
that fits on my new page, with the idea of pasting into it, and then
sorting out the spacings, but I have not yet even found a way of so
pasting.

The best method I have come up with so far is simply pasting the copied
row as unformated text, and then manually inserting the various elements
into the appropriate cell of a new table; which achieves the desired
result in the end, but is going to be cumbersome over several hundred
photos.

Any suggestions as to the most efficient way to proceed will be greatly
appreciated.

Sincerely

Ian Graham


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems?
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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.