I have a Writer document that has numbered sections. From the navigator, I can drag or drop a link to a spreadsheet cell (or a hyperlink by changing the option). I really only want to show the numbered section in the spreadsheet cell and not all of the text. I also want the number to change if the source document changes.
If I create the link, I can manually modify the text, but if the numbering changes, the cell in the spreadsheet is not updated. Also if I delete and add sections, sometimes the links are broken.
Is there a way of doing this reliably?