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
