Re: [libreoffice-users] Multi-source Mail Merge
Thank you for your response. I am using ubuntu 14.04, however ideally any solution would be Excel compatible if possible. In regard to your suggestion, perhaps I'm missing something but I don't see the advantage of inserting a DDE link (assuming I can even do that). The problem I need to solve is how to avoid having to change the data source manually, I do not think your solution addresses that problem? On 05/10/2015 12:06 PM, Mike wrote: Regarding: "I have multiple spreadsheet files that each represent one unique item. As an analogy, think of the spreadsheet as a basket that contains a variety of eggs (both calculated and hand-entered data). I have multiple baskets each with multiple eggs. Each basket (spreadsheet) is associated with one person. Each person can have multiple baskets (although that's probably not relevant). I also have a letter, with which I want to do a mail merge - against each spreadsheet. i.e. each letter needs to draw multiple pieces of data (eggs) from each spreadsheet, one letter per spreadsheet. Normally to do a mail merge you have one data source. The problem of course is that I don't have one data source, I have an unknown number - each spreadsheet is a data source. So I'm at a loss as to how to mail merge against multiple data sources in an automated fashion." You don't specify OS; I am using Windows 7 Pro and this may work for you: Copy cell (or select and copy a range) from spreadsheet Click on word processor Click on Edit/Paste Special Click on DDE link Click on OK Any changes to spreadsheet will be reflected in the Word processor You will have to adjust size and location of pasted data. You can repeat this procedure for any other spreadsheets - you are not limited to just one source. This works well for cells and cell ranges, but not well with an entire spreadsheet. For an entire spreadsheet, I tried using Insert/Object/OLE Object/Create from file/Link to file and then navigating to the desired file. I then double clicked on the desired file and then on the OK button. The spreadsheet is inserted, but I cannot get it to display properly. If I right click on the spreadsheet and then on edit the spreadsheet is displayed, but as soon as I click anywhere in the word processor document all I see is a black box instead of the spreadsheet data. BTW, my first reaction to your question is that, depending on the complexity of the calculations, a database application sounds more suitable for your needs, but that is probably not a useful recommendation for you at this point. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Multi-source Mail Merge
Thank you for your response. Each letter to be generated relies on one single spreadsheet for all its data. On 05/10/2015 07:28 AM, Mark Stanton wrote: This sounds like an interesting problem. So, just doing it manually, how do *you* know how many spreadsheets are required for any particular result? Mark Stanton One small step for mankind... In article <554e54ba.9070...@bak.rr.com>, A wrote: I have multiple spreadsheet files that each represent one unique item. As an analogy, think of the spreadsheet as a basket that contains a variety of eggs (both calculated and hand-entered data). I have multiple baskets each with multiple eggs. Each basket (spreadsheet) is associated with one person. Each person can have multiple baskets (although that's probably not relevant). I also have a letter, with which I want to do a mail merge - against each spreadsheet. i.e. each letter needs to draw multiple pieces of data (eggs) from each spreadsheet, one letter per spreadsheet. Normally to do a mail merge you have one data source. The problem of course is that I don't have one data source, I have an unknown number - each spreadsheet is a data source. So I'm at a loss as to how to mail merge against multiple data sources in an automated fashion. Thank you in advance. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Multi-source Mail Merge
Thank you for your response. I looked at the link you provided. That's an interesting solution, but I'm not sure it would work. It's probably important to know that there are multiple sheets in each spreadsheet file. Also, I don't know how I'd find the cells I need once the files are merged. For example if I need data from A2, C3, `sheet2`D11, F32 and G12 in each file, merging the files would mean A2 is suddenly A42 or some such for what was file2. I don't see how to make this work. On 05/10/2015 11:33 AM, Andreas Säger wrote: Merge all sheets into one and do what you want with it: https://forum.openoffice.org/en/forum/viewtopic.php?f=21&p=351686 -- View this message in context: http://nabble.documentfoundation.org/Multi-source-Mail-Merge-tp4148287p4148330.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] merging layers
I'm working on a graphic in LO Draw with several layers. Now I want to merge those layers, but I can't find how to do that. I tried grouping but I can only select one element at a time, even with 'Shift' held down. Thanks. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Form navigator button not working in LO base
I have been successfully designing forms with subforms in LO Base using the form navigator. Strangely the form navigator has just stopped working. When I click on the icon, nothing happens. No further information is displayed. I have rebooted, uninstalled LO and reinstalled version 4.4.3.2, created a new test database from scratch and the form navigation button still fails to do anything. All the other icons in the form design toolbar work. Help! Thanks, Paul Fearnley -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Multi-source Mail Merge
Regarding: "I have multiple spreadsheet files that each represent one unique item. As an analogy, think of the spreadsheet as a basket that contains a variety of eggs (both calculated and hand-entered data). I have multiple baskets each with multiple eggs. Each basket (spreadsheet) is associated with one person. Each person can have multiple baskets (although that's probably not relevant). I also have a letter, with which I want to do a mail merge - against each spreadsheet. i.e. each letter needs to draw multiple pieces of data (eggs) from each spreadsheet, one letter per spreadsheet. Normally to do a mail merge you have one data source. The problem of course is that I don't have one data source, I have an unknown number - each spreadsheet is a data source. So I'm at a loss as to how to mail merge against multiple data sources in an automated fashion." You don't specify OS; I am using Windows 7 Pro and this may work for you: Copy cell (or select and copy a range) from spreadsheet Click on word processor Click on Edit/Paste Special Click on DDE link Click on OK Any changes to spreadsheet will be reflected in the Word processor You will have to adjust size and location of pasted data. You can repeat this procedure for any other spreadsheets - you are not limited to just one source. This works well for cells and cell ranges, but not well with an entire spreadsheet. For an entire spreadsheet, I tried using Insert/Object/OLE Object/Create from file/Link to file and then navigating to the desired file. I then double clicked on the desired file and then on the OK button. The spreadsheet is inserted, but I cannot get it to display properly. If I right click on the spreadsheet and then on edit the spreadsheet is displayed, but as soon as I click anywhere in the word processor document all I see is a black box instead of the spreadsheet data. BTW, my first reaction to your question is that, depending on the complexity of the calculations, a database application sounds more suitable for your needs, but that is probably not a useful recommendation for you at this point. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Multi-source Mail Merge
Merge all sheets into one and do what you want with it: > https://forum.openoffice.org/en/forum/viewtopic.php?f=21&p=351686 -- View this message in context: http://nabble.documentfoundation.org/Multi-source-Mail-Merge-tp4148287p4148330.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users]
Do you have experience with programming? If not - you're not going to be able to change these things. You'll have to build LibreOffice and hack the code in order to make these changes. Best, Joel On Thu, May 7, 2015 at 7:36 AM, Grettel Barrio Marshall wrote: > /This is what I mean, Start Center. How I can change the color? Thank you > very much for the links you sent me./ > > -- > > /*Ing.*Grettel Barrio Marshall > *Dpto. Servicios Integrales en Migración, Asesoría y Soporte > Centro de Software Libre > Universidad de las Ciencias Informáticas > Teléfono:* (07) 837-2531 > / > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- *Joel Madero* LibreOffice QA Volunteer jmadero@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users]
Hi :) Sorry you haven't had any answers! I'm not sure how to change the "Start Centre" if it's not affected by the themes/personalisation and i am guessing it isn't otherwise the problem would have been solved by now! Hopefully someone here might be able to help sometime! Apols and regards from Tom :) 2015-05-07 15:36 GMT+01:00 Grettel Barrio Marshall : > *This is what I mean, Start Center. How I can change the color? Thank > you very much for the links you sent me.* > -- > > > > > > > *Ing.Grettel Barrio Marshall Dpto. Servicios Integrales en Migración, > Asesoría y Soporte Centro de Software Libre Universidad de las Ciencias > Informáticas Teléfono: (07) 837-2531 * > > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Multi-source Mail Merge
On 9-5-2015 20:40, A wrote: I have multiple spreadsheet files that each represent one unique item. As an analogy, think of the spreadsheet as a basket that contains a variety of eggs (both calculated and hand-entered data). I have multiple baskets each with multiple eggs. Each basket (spreadsheet) is associated with one person. Each person can have multiple baskets (although that's probably not relevant). I also have a letter, with which I want to do a mail merge - against each spreadsheet. i.e. each letter needs to draw multiple pieces of data (eggs) from each spreadsheet, one letter per spreadsheet. Normally to do a mail merge you have one data source. The problem of course is that I don't have one data source, I have an unknown number - each spreadsheet is a data source. So I'm at a loss as to how to mail merge against multiple data sources in an automated fashion. Thank you in advance. If one person has multiple baskets (=sheets), will this person receive one letter? or multiple letters? This looks like (in SQL): SELECT egg1, egg2, egg3 FROM basket1 UNION SELECT egg2, egg3, egg4 FROM basket2 UNION SELECT egg3, egg4, egg5 FROM basket3 How equal/similar are these eggs, and the number of eggs in a basket? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Multi-source Mail Merge
This sounds like an interesting problem. So, just doing it manually, how do *you* know how many spreadsheets are required for any particular result? Mark Stanton One small step for mankind... In article <554e54ba.9070...@bak.rr.com>, A wrote: > I have multiple spreadsheet files that each represent one unique item. > As an analogy, think of the spreadsheet as a basket that contains a > variety of eggs (both calculated and hand-entered data). I have multiple > baskets each with multiple eggs. Each basket (spreadsheet) is > associated with one person. Each person can have multiple baskets > (although that's probably not relevant). > > I also have a letter, with which I want to do a mail merge - against > each spreadsheet. i.e. each letter needs to draw multiple pieces of > data (eggs) from each spreadsheet, one letter per spreadsheet. > > Normally to do a mail merge you have one data source. The problem of > course is that I don't have one data source, I have an unknown number - > each spreadsheet is a data source. So I'm at a loss as to how to mail > merge against multiple data sources in an automated fashion. > > Thank you in advance. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
