Ask Your Question

Writer: Rows missing in modified linked spreadsheet

asked 2019-12-04 08:37:36 +0200

elektronaut gravatar image

updated 2019-12-04 09:39:05 +0200

In a Writer document, I have a table which reflects the content of an area in a linked spreadsheet. If I modify the link so that the displayed table should contain more rows, these added rows don't show up at all. Is there something in the document which might impede it?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-12-09 12:24:21 +0200

elektronaut gravatar image

Given that I don't find any hint that you can restrict the content of a linked OLE spreadsheet to a certain area (if you simply copy & paste, you get an embedded OLE spreadsheet, which data is not updated if the source data file changes), and modifying the DDE link didn't work, I now unlinked the table, deleted it, and recreated it again as a DDE link (via right-click paste option). Maybe I'm missing something about OLE objects here, but this is what worked for me.

edit flag offensive delete link more

answered 2019-12-04 09:12:19 +0200

ebot gravatar image

How did you do the OLE integration?

When you choose OLE Object in Writer from the Insert>Object>OLE-Object menu, an Insert OLE Object dialog box appears.

There you choose "Create from file".

Find your ODS file and click the check mark next to "Show as icon".

If you then double-click on the Calc icon in Writer, Calc will open completely.

edit flag offensive delete link more


Thank you for your answer! I don't remember how I inserted the data initially as it was a long time ago. Now, when I go to Edit>Links to External Files..., I can modify the area, e.g. changing Category from 'my_spreadsheet'.A28:E32 to 'my_spreadsheet'.A28:E34, but the two added lines won't be displayed. One thing I'm just noticing now when I look at the pop-up header - it says Modify DDE Link. So it seems this is DDE, not OLE? Might this be a problem?

elektronaut gravatar imageelektronaut ( 2019-12-04 09:22:51 +0200 )edit

Which OS and LibreOffice-Version do you use?

Do you have your spreadsheet document in the same path as Writer's ODT?

ebot gravatar imageebot ( 2019-12-04 10:04:13 +0200 )edit

MacOS 10.14.6, LibreOffice Both ODS & ODT are in the same folder. The link itself definitely works, data is updated. Just the change in display area yields no effect.

elektronaut gravatar imageelektronaut ( 2019-12-04 15:53:02 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-12-04 08:37:36 +0200

Seen: 47 times

Last updated: Dec 09 '19