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

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