the Spacing to contents values in your tables properties). Perhaps the visual results will be slightly different on your document, depending on the customization of your styles (e.g. You can manually update the DDE link value by pressing F9. Now, every time you change the cell contents in your calc spreadsheet, the value in your writer document will be updated to reflect the changes. This is the final result you will -wishfully- achieve: You just need to cut & paste it to the right position Your calc cell value will probably be displaced somewhere in the beginning of your paragraph, but that is no problem.Go to Borders tab, select No Borders and set Spacing to contents to zero.Go to Wrap tab and set Left and Right values to zero.You also want to check the Automatic option in width You want to Anchor your frame As character and select a Center to Baseline Vertical alignment.Now, select the whole cell by putting the cursor on the left border of the page until it is turned into a right-facing black arrow.Reduce cell width by dragging its far right side towards the left, just so that your value has enough space to be displayed (bearing in mind that your spreadsheet value might change and become bigger).Remove the table’s border by inserting the cursor in the cell, right clicking, Table/Borders and Set no borders.If you Paste special the cell value then you get the following result:īut don’t freak out! Our problem is not the DDE link per se, but rather the way it is displayed! So what we need to do is change its format so that it stays put at the desired position. Let’s assume, for example, that you have the following line of text in a writer documentĪnd you want to place a linked calc spreadsheet value after the colon. What if you want this value to be in-line with the rest of the text? The apparent problem when using this option, though, is that the resulting value is pasted in a one-line table.

This is done by copying the cell value from calc and then Paste special / DDE Link in the document.

What I rather needed was to have some value in my document that would be updated from the respective spreadsheet cell, whenever it changed. This is used when you want to merge multiple values at a specific place in your document, to produce many documents with the same general layout, but with different field values (it is referred to as mail merge). My first impulse was to use Inser/Field and use the database connector, but that didn’t work for me. Working with Libreoffice Writer I found myself in need to link some specific numerical values to a calc spreadsheet.

Libreoffice writer document