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:
(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.