Ask Your Question

vzjrz's profile - activity

2014-04-05 07:43:41 +0200 received badge  Popular Question (source)
2014-04-05 07:43:41 +0200 received badge  Notable Question (source)
2014-04-05 07:43:41 +0200 received badge  Famous Question (source)
2013-07-13 09:35:13 +0200 asked a question Clickable import list of url hyperlinks into Calc

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.