Ask Your Question

Text plain to hyperlink in Calc

asked 2018-10-17 14:11:59 +0200

Arconada28 gravatar image

Hi all,

I have imported a column from a CSV to an ODS file with links (local files, not url) to photos like this:


file:///usr/people/myuser/file2.jpg ...

By now they are text plain and I'd like to convert them to clickable hyperlinks. If I rewrite manually the routes, it works, but I have hundreds of files and I need to do it in an automatic way.

Any suggestions? Many thanks in advance!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-10-19 13:08:07 +0200

jfn gravatar image


did you check the Ask-ed questions beforehand?

Also, querying my preferred search engine: "calc automatic convert text to hyperlink"

I found this question (and response :-)

Does it fit your needs?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-17 14:11:59 +0200

Seen: 444 times

Last updated: Oct 19 '18