Ask Your Question
0

Writer: Rows missing in modified linked spreadsheet

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

elektronaut gravatar image

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

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

1 Answer

Sort by » oldest newest most voted
0

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

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

Comments

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 +0100 )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 +0100 )edit

MacOS 10.14.6, LibreOffice 6.3.3.2. 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 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 12 times

Last updated: Dec 04