When I insert an OLE table from a Calc (ods) spreadsheet into a Writer (odt) document this way:
- Insert > Object > OLE object
- 🗹 Create from file
- 🗹 Link to file
it imports the table that’s in the active sheet in Calc. Makes sense so far, although it would be nice to have a dropdown list to chose a sheet from.
But my problem is that I would like to link tables from multiple sheets in the same ods file into my Writer document. However, if I try to do so, as soon as I reload the Writer document, all the OLE tables switch to the same sheet and display the same table.
Is there no way to specify which sheet should be displayed in any specific OLE table and lock it for good while still retaining the link to the data in the Calc file?