Clickable import list of url hyperlinks into Calc [closed]

asked 2013-07-13 09:35:13 +0100

vzjrz gravatar image

Whenever I import a list of links into Calc they always appear as plain text and I can't click to open them. I have to edit them slightly for Calc to auto-recognize them as url's and I have to do this one by one.

I found similar questions like mine but none show you how to change the style/formatting of many cells in cal:

ask.libreoffice.org/en/question/2936/i-have-email-addresses-and-want-them-as-links-but-the-are-normal-text-how-to-convert-them/

ask.libreoffice.org/en/question/6393/how-may-i-do-writer-recognize-hyperlinks-automatically/

(I wish this worked in Calc)

I also know that I could use the HYPERLINK function but I don't really want to use that just want to change the style/formatting.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-04 19:49:37.438183