Re: [libreoffice-users] Importing a row from a spreadsheet

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