Can a DDE link between Calc and Writer be edited to Inline?

English
#1

Ok, here goes.
I’m using LO Version: 7.5.5.2 (X86_64) / LibreOffice Community
Build ID: ca8fe7424262805f223b9a2334bc7181abbcbf5e
CPU threads: 4; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
I am an electrician, creating bids to submit to companies.
I have two documents, a Calc sheet and a Writer doc.
The calc sheet is to create a bid estimate for an electrical project.
It contains data such as the project title, final cost, customer name and address, phone number.
The Writer doc is the formal bid that I send to the GC (general contractor)
I searched here and found how to link a Calc cell to a Writer doc using Dynamic Data Exchange. That creates a 1-cell table in Writer using the data from my calc sheet, and updates as I change the Calc sheet. Great, fine and dandy. Except it creates this table as a full-width object, even if I resize the table cell to be placed 0.5 from left and 5" from right.
I want to be able to include a cell from the Calc sheet (bid cost) in line with the Writer doc so it says:

“The final cost of the project will be bid cost from calc sheet and will be payable according to the following draw schedule:”

But all I can seem to create is:

“The final cost of the project will be
bid cost from calc sheet
and will be payable according to the following draw schedule:”
Screenshots available as soon as I figure out how to attach them…

#2

I think, you want a serial letter, aka form letter.
menu:File>New>Database…
[X] COnnect to existing database of type “Spreadsheet”.
Specify your spreadsheet document.
[X] Yes, register the data source (use it with arbitrary office documents).
Save and close the database document.
Nothing has been copied, exported nor converted. All your data are still in the spreadsheet.

In Writer hit Ctrl+Shift+F4 for the data source window.
In the left pane, browse to the right table in your data source and select it.
From the right pane, drag column headers into your Writer document.
This creates mail merge fields. Now you can print/export one Writer document for each record in the data source where the mail merge fields are replaced with the respective contents.
You can also print/export Writer documents for selected/filtered records.
You can select a single record in the data source window and click the “Data to fields” button which fills the mail merge fields with data from the selected record.

#3

Thanks, I thought I was going to have to use Base somehow.

#4

I used to create DDE links via menu:Insert>Fields>MoreFields [Ctrl+F2], tab “Variables”, DDE field.
DDE_Field.odt (11.8 KB)
DDE_Source.ods (15.0 KB)

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.