Ask Your Question

Lock which sheet to display in OLE table?

asked 2020-06-03 19:39:13 +0100

ChameleonScales gravatar image

updated 2020-06-05 10:42:27 +0100

When I insert an OLE table from a Calc (ods) spreadsheet into a Writer (odt) document this way:

  1. Insert > Object > OLE object
  2. 🗹 Create from file
  3. 🗹 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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-06-05 12:28:38 +0100

m.a.riosv gravatar image

One way:

  • Insert a 'Create new' spreadsheet OLE object.
  • Being in this spreadsheet link to the spreadsheet with the data, using Menu/Sheet/Link sheet from file o Link to external data.
  • But you need to enter the embedded spreadsheet to update the links Menu/Edit/Links to external files
edit flag offensive delete link more


( ྃ Д ྃ ) smart. Thank you.

ChameleonScales gravatar imageChameleonScales ( 2020-06-05 13:35:40 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-06-03 19:39:13 +0100

Seen: 57 times

Last updated: Jun 05 '20