[libreoffice-users] Importing a row from a spreadsheet
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+unsubscr...@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
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+h...@global.libreoffice.org wrote: Subject: [libreoffice-users] Importing a row from a spreadsheet From: Ian Graham 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+unsubscr...@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
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 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+h...@global.libreoffice.org wrote: > > Subject: > > [libreoffice-users] Importing a row from a spreadsheet > > From: > > Ian Graham > > 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+unsubscr...@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+unsubscr...@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
Re: [libreoffice-users] Importing a row from a spreadsheet
Ian, if you reply, please reply to users@global.libreoffice.org, not my email. Thank you. I created a twelve (12) column spreadsheet, A to L, with two rows in Calc, then selected A1:L2, then copied and pasted it into Write. That had the same result as you described, columns disappearing off the right of the page. HOWEVER, when I created an empty one (1) row, twelve (12) column table in Write FIRST and then pasted the Calc selection into it (cursor at R1, C1 of table in Write) both rows were pasted into the table and the table did not expand beyond the margins of the page. If you haven't tried creating a blank, one row table in Write, with the same number of columns as your source spreadsheet, give that a shot. Create the table in Write. Only need one row but need the same number of columns as in your source spreadsheet. Then, copy the rows and columns in the spreadsheet. And finally paste into R1, C1 in the Write table. See if that produces the result you're looking for. Also, if you wish to have an individual one row table in Write for each item in the catalog, proceed with the copy/paste as described above. The resulting table in Write will have one row for each row pasted from Calc. To separate the rows in Write, put your cursor in any row, then select Table>Split Table... from the menu. Select the "No heading" option and click "OK" button. Repeat as many times as you need to break the table into individual rows. On Wed, Apr 26, 2023 at 6:48 AM Ian Graham wrote: > 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+unsubscr...@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 > -- Alan Boba CISSP, CCENT, ITIL v3 Foundations 2011 -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Importing a row from a spreadsheet
I'm sorry, Alan. I'm not sure how that happened - I thought I clicked on reply to the original group email in the usual way, and it was only after it went, that I realised it had gone to your private address, and I reposted to the group. On 30/04/2023 19:56, Alan B wrote: > Ian, if you reply, please reply to users@global.libreoffice.org, not > my email. Thank you. > -- To unsubscribe e-mail to: users+unsubscr...@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
Fwd: [libreoffice-users] Importing a row from a spreadsheet
And as if to suggest there may be some sort of mismatch interference going on, I now find the same mistake about 'reply' as before has recurred. Sorry again, Alan. Forwarded Message Subject: Re: [libreoffice-users] Importing a row from a spreadsheet Date: Mon, 1 May 2023 10:25:23 +0100 From: Ian Graham To: Alan B Good morning, Alan and group Thank you for your continuing interest in this, Alan. What you describe is what I first attempted, on the basis of using LibreOffice for many years. However, my original outcome was not as you described, which is what set me off searching further. I have now tried again done what you have said, twice, first inserting the cursor in the first LH cell of the Writer table, and secondly selecting the whole row. Both times if I simply 'Paste', what I get seems to be a graphic ie image of the selected part of the spreadsheet, with no obvious relation to the created table, and no editable capacity. I am in Trisquel, which is a somewhat ipsative version of Gnu Linux, and I'm now wondering if that may have something to do with the responses I'm getting. And just for the avoidance of doubt, I have found a work-round I can live with, as I noted in an earlier post. Sincerely Ian G. On 30/04/2023 19:56, Alan B wrote: > Ian, if you reply, please reply to users@global.libreoffice.org, not > my email. Thank you. > > I created a twelve (12) column spreadsheet, A to L, with two rows in > Calc, then selected A1:L2, then copied and pasted it into Write. > > That had the same result as you described, columns disappearing off > the right of the page. > > HOWEVER, when I created an empty one (1) row, twelve (12) column table > in Write FIRST and then pasted the Calc selection into it (cursor at > R1, C1 of table in Write) both rows were pasted into the table and the > table did not expand beyond the margins of the page. > > If you haven't tried creating a blank, one row table in Write, with > the same number of columns as your source spreadsheet, give that a shot. > > Create the table in Write. Only need one row but need the same number > of columns as in your source spreadsheet. > > Then, copy the rows and columns in the spreadsheet. > > And finally paste into R1, C1 in the Write table. > > See if that produces the result you're looking for. > > Also, if you wish to have an individual one row table in Write for > each item in the catalog, proceed with the copy/paste as described > above. The resulting table in Write will have one row for each row > pasted from Calc. > > To separate the rows in Write, put your cursor in any row, then select > Table>Split Table... from the menu. Select the "No heading" option and > click "OK" button. Repeat as many times as you need to break the table > into individual rows. > > > > > On Wed, Apr 26, 2023 at 6:48 AM Ian Graham > wrote: > > 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 >
[libreoffice-users] Importing a row from a spreadsheet - solved, sort of.
Thank you, Mike for your interest and suggestion. I was not familiar with the concatenate function, and it does look a powerful one. But I am not sure it helps me greatly in what I want to do, since I do wish to retain the cell identities – it’s just that I want them in more readily presentational-editable form. What I have done for the moment is to select the entire range of active cells in the document, copy them, and then paste-special-HTML into a new odt, which gives me a simple text table. From there it is straightforward to select and copy content re a single item to a slightly different (more reader-friendly) table to accompany the image to which it refers. It is not clear to me why whoever set up the original index chose to do so as a spreadsheet. There is very little likelihood of the sophisticated ‘search’ functions being used. Conversely, I am a great fan of tables in odts – use them all the time for all sorts of purposes, sometimes merely transitional. Sincerely Ian Graham On 29/04/2023 11:46, Mike Flannigan wrote: > concatenate command -- To unsubscribe e-mail to: users+unsubscr...@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
