Ask Your Question

Calc: How to Split Contents without losing Hyperlinks?

asked 2019-05-16 18:52:08 +0200

crashb648 gravatar image

So I'm currently spliting some data into two coloums. The data is like this: Angel Beats! | Netflix I try to use Data to Coloums Feature, but when I do, the hyperlink disappears completely. How do I stop it doing that? And have the content and Hyperlink not to disappear.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-05-16 19:27:29 +0200

Lupp gravatar image

updated 2019-05-16 19:37:22 +0200

A hyperlink of the kind you get whe n using the link editor for a part of the text constant contained in a cell cannot be created by a formula. If the target URL is also used for the text it is anchored to, you can create a working link of a different type with the help of the HYPERLINK() function. Otherwise you need to extract the URL from the TextField object it was assigned to. I don't know way to do this based on standard functions of Calc, but I once wrote a user function capable of doing it. It is published in the CodeSnippets branch of the

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-05-16 18:52:08 +0200

Seen: 25 times

Last updated: May 16