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 <[email protected]> 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, [email protected] wrote: > > Subject: > > [libreoffice-users] Importing a row from a spreadsheet > > From: > > Ian Graham <[email protected]> > > Date: > > 4/26/23, 05:47 > > > > To: > > [email protected] > > > > > > 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: [email protected] > 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: [email protected] 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
