Ask Your Question
0

Text plain to hyperlink in Calc

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

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/file1.jpg

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
0

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

jfn gravatar image

Hello!

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 :-) https://ask.libreoffice.org/en/questi...

Does it fit your needs?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 24 times

Last updated: Oct 19 '18