Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

On 11/09/2012 09:41 AM, paulwhitehurst wrote:

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


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.