5

I have a list of text urls in, how i can convert all of them into clickable links?

Jask
  • 660
  • 10
  • 23

3 Answers3

4

HYPERLINK does not solve the problem. As a result, we will have two columns: the original and the results of the formula. The question was how to CONVERT urls into clickable links. My method: 1. Cut the column from calc. 2. Paste as plain text into writer (shift-ctrl-v). 3. Format > AutoCorrect > Apply. 4. Copy links back to calc.

Maciej Czub
  • 41
  • 1
4
HYPERLINK(linkaddress; celltext)
Jask
  • 660
  • 10
  • 23
  • 1
    The result is quite different from the result one obtains when one explicity does "Insert > Hyperlink". That's damned inconsistent. – David Tonhofer Jul 13 '15 at 10:18
1

Hopefully you found a solution in the 6+ years since your question, but it may help others searching for the same solution.

Converting them in openoffice-calc is a cumbersome process.

It's much easier to copy them to openoffice-writer and covert them there, then copy them back:

  1. Copy and paste the list of urls into a openoffice-writer document.

  2. From the Format menu, choose AutoCorrect, then AutoCorrect Options...

  3. On the Options tab, click both the [M] and [T] boxes next to URL Recognition and click the OK button.

  4. Select the list, go to Format > AutoCorrect > Apply.

  5. Copy the url list back to openoffice-calc.

Hope this helps someone!

ChasVA
  • 11
  • 1
  • For LibreOffice 7.2.5.2.0 (and probably some similar versions) the `AutoCorrect` item is under `Tools` and has subitems, from which you need to select `Apply`. – Dirk Jun 02 '22 at 14:45