We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question
0

Formatted DDE link from calc to writer

asked 2020-08-13 11:45:43 +0200

Murmele gravatar image

Hi there,

I have a calc table which is already formatted and there are url's in it. Is it possible to include the calc table into writer, whith preserved link to the calc table, preserved table format and preserved url so that I can click in writer to open the url in the browser?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2020-08-14 06:47:31 +0200

Earnest Al gravatar image

updated 2020-08-14 10:51:57 +0200

In your Writer document place cursor where you want the table. Click Insert > Object > OLE Object.... In the dialog that opens check the radio button "Create from File", tick the box labelled "Link to file", navigate to the spreadsheet file by clicking on the Search button, click Open, then click OK.

Size the object to suit. To access the links you will have to double-click the object after which you can Ctrl+click any of the links. Note: Export to PDF does not retain the links

edit flag offensive delete link more

Comments

Thank you for the answer, but this solves not the problem in the pdf export

Murmele gravatar imageMurmele ( 2020-08-14 15:35:20 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-08-13 11:45:43 +0200

Seen: 54 times

Last updated: Aug 14 '20