Is is possible to add a writer document into a Calc spreadsheet ? Ideally, what I would like to do is have a calc document with a writer document showing as one of the sheet tabs, i.e. selecting that tab in calc opens the writer document on that tab.
From the menu, choose Insert>Object>OLE Object ....
In the “Insert OLE object” dialog box, select “Create from file”.
Choose your Writer document. Put a checkmark next to “Link to file”. If you now select “Show as icon”, you can later double click on the icon to open the file. Otherwise, the Writer document will be displayed directly.
If you want to associate the opening of the Writer document with the selection of the table, you will probably need a macro. Unfortunately I can not help you with that.
With me Windows 10, Version 1809, 64-Bit | LibreOffice, Version: 6.2.2.2 (x64.