When to use which linking method in Calc

asked 2019-09-12 04:25:15 +0100

catbill gravatar image

updated 2019-09-12 12:51:10 +0100

Opaque gravatar image

The Calc user guide describes four methods for linking data (excluding hyperlinks):

  • Link to external data
  • Link to registered data source
  • DDE
  • OLE

I can see how to use them but because I don’t know much about their inner workings, it is hard for me to evaluate when to use each method.

I would like to understand the conditions under which each method is most appropriate as well as the advantages and disadvantages of each method, especially for linking charts

Criteria I could see using include:

  • Ease of creating and maintaining
  • Ease of updating
  • Security
  • Other?

I am looking for general ideas and don’t have a specific use case. However, please feel free to give examples.

If this question does not seem appropriate for this forum, then please advise me where it would be more appropriate to post it.

Edit [Opaque] Improve readability (list items)

edit retag flag offensive close merge delete


@catbill - just a hint: It is not sufficient to add a line break, if you want create a list of items. A minimum of two spaces at the end of a line before you ENTER is required to make it appear as a single line (even better: make use of the list item formatting)

Opaque gravatar imageOpaque ( 2019-09-12 10:46:00 +0100 )edit

Thank you for fixing this up, Opaque. I had pasted this in and neglected to do look at the formatting. You are a thoughtful person and I hope you can share your thoughts about links:)

catbill gravatar imagecatbill ( 2019-09-12 15:06:25 +0100 )edit