[libreoffice-users] Re: Links in a writer document
Hi :) Something like this? calcINwriter.odt http://nabble.documentfoundation.org/file/n4017696/calcINwriter.odt If it works then you see an outlined but apparently empty box. When you double-click inside the box you see like a calc spreadsheet. If you put stuff into those cells then when you click outside the box (back in the normal Writer area) then you see whatever you typed into those cells. I'm not sure if that is how you are supposed to do it but the modules/apps of LO are meant to operate together in a very much more tightly integrated way than most rivals. Most rivals treat the different apps/modules (Writer, Calc, Impress etc) as different apps that standalone. StarOffice took a different approach. I'm not sure if my way is what you are looking for so here is a link to documentation http://wiki.documentfoundation.org/Documentation/Publications Hopefully someone will soon write in with more accurate ideas that help you better than my quick 2 minute fumbling around. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Links-in-a-writer-document-tp4017587p4017696.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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: Links in a writer document
Tom: Thanks. That's what I tried. My idea for the form was to allow the user to fill in data in a Writer table cell. Then, inside the spreadsheet I wanted to insert a DDE link to the cell in a Writer table. The spreadsheet would do the calculations for the form and generate the result. Ideally I could also link the output of the spreadsheet back to a cell in the Writer table. The problem with doing it this way is that the the spreadsheet doesn't refresh when I enter data in the Writer table cell. I tried creating the OLE object as a new Calc file, but it doesn't refresh. I tried creating the OLE object from an existing Calc file. I got some of the cells in the existing Calc file to refresh pretty well, but it didn't refresh the OLE object embedded in the Writer document. In any event, I would prefer not having two files. I would like to distribute this form. I expect potential users would be unfamiliar with LO. I expect it would be to hard for them to use it because both the files would need to be in the same directory and all the links between the files made to work. I can send you a draft of the form I'm working on to see if you might have some suggestions. Paul Whitehurst -- View this message in context: http://nabble.documentfoundation.org/Links-in-a-writer-document-tp4017587p4017745.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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: Links in a writer document
Hi :) It sounds like you need to use Base for this. Base is best as a decent database front-end and then have it reading/writing the data securely in a decent back-end such as, well it depends on roughly how much data you think you are going to generate. MySql/MariaDb and Postgresql are very hefty and probably far larger than you will need. There is some documentation about using Base http://wiki.documentfoundation.org/Documentation/Publications but it's a bit of a work-in-progress. Regards from Tom :) From: paulwhitehurst whan...@aol.com To: users@global.libreoffice.org Sent: Friday, 9 November 2012, 14:41 Subject: [libreoffice-users] Re: Links in a writer document Tom: Thanks. That's what I tried. My idea for the form was to allow the user to fill in data in a Writer table cell. Then, inside the spreadsheet I wanted to insert a DDE link to the cell in a Writer table. The spreadsheet would do the calculations for the form and generate the result. Ideally I could also link the output of the spreadsheet back to a cell in the Writer table. The problem with doing it this way is that the the spreadsheet doesn't refresh when I enter data in the Writer table cell. I tried creating the OLE object as a new Calc file, but it doesn't refresh. I tried creating the OLE object from an existing Calc file. I got some of the cells in the existing Calc file to refresh pretty well, but it didn't refresh the OLE object embedded in the Writer document. In any event, I would prefer not having two files. I would like to distribute this form. I expect potential users would be unfamiliar with LO. I expect it would be to hard for them to use it because both the files would need to be in the same directory and all the links between the files made to work. I can send you a draft of the form I'm working on to see if you might have some suggestions. Paul Whitehurst -- View this message in context: http://nabble.documentfoundation.org/Links-in-a-writer-document-tp4017587p4017745.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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: Links in a writer document
On 11/09/2012 09:41 AM, paulwhitehurst wrote: Tom: Thanks. That's what I tried. My idea for the form was to allow the user to fill in data in a Writer table cell. Then, inside the spreadsheet I wanted to insert a DDE link to the cell in a Writer table. The spreadsheet would do the calculations for the form and generate the result. Ideally I could also link the output of the spreadsheet back to a cell in the Writer table. The problem with doing it this way is that the the spreadsheet doesn't refresh when I enter data in the Writer table cell. I tried creating the OLE object as a new Calc file, but it doesn't refresh. I tried creating the OLE object from an existing Calc file. I got some of the cells in the existing Calc file to refresh pretty well, but it didn't refresh the OLE object embedded in the Writer document. In any event, I would prefer not having two files. I would like to distribute this form. I expect potential users would be unfamiliar with LO. I expect it would be to hard for them to use it because both the files would need to be in the same directory and all the links between the files made to work. I can send you a draft of the form I'm working on to see if you might have some suggestions. Paul Whitehurst The Writer Guide contains Chapter 15, Using Forms in Writer. This sound like what you want to accomplish. The entire Guide or this chapter can be downloaded from http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Writer_Guide --Dan -- For unsubscribe instructions e-mail to: users+h...@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