Link writer text value to calc cell

Hi, I want to take an inline value that is linked to a Calc cell such that when I change the value in the Calc cell it will change the value in Writer. The problem I have with past special / DDL link is it creates a whole new row.

In MSword and excel you use past special / unformatted text /past link (Am trying to get away from MS)

So if in Calc the cell value is Cat then Writer will have This is a Cat. and if I change the cell value to Dog then Writer has This is a Dog.

Thank you for your assistance in advance

Insert a DDE field:

1 Like

Thank you that did it.