Hyperlinks do not work copying cells over different sheets

[Kennish]

Hi There,

I’m creating a Libre Office Calc document to generate some PDF files. In this document is a master sheet called “General Information” here I can fill in all the general information that I need for the following sheets.

All the following sheets inputs are linked to the master sheet by using for example:

=$‘General Information’.A1

However when I try to do this for a cell in the master sheet with a Hyperlink (for example a Email or Website). The text gets copied as desired but the Hyperlink won’t work.

Is there a way that I can also copy the cells hyperlink from my master sheet?

Thanks in advance!

Ken

[Lupp]

Formulas don’t copy anything, but calculate a result and deliver it to the cell where the formula is contained in.
In the cases where the result is “text” it actually never consists of parts inserted as TextContent (like hyperlinks), but is a simple string.
If your master sheet GeneralInformation contains the text for display and the linked URL separately, say in adjacent cells, you can use the HYPERLINK() function to get a working link in the cell containing the formula. If you entered the link “in one go” you would need to separate the representation and the URL explicitly before you can get them both using a formula. There is no standard function for the purpose. UserCode needed.
If you entered the “link” as an URL without any additional cell content, but actually complete, including the protocol part, and got it automatically converted to a working link, you can use the reference to the containing cell with (e.g.) =HYPERLINK($GeneralInformation.A1), and the displayed result should work again.
Functionally linked text created with HYPERLINK should also result in working links when exported to pdf.

[Kennish]

@Lupp

thout any additi

Hi Lupp,

Thanks for your reply, You send me in the perfect direction.

For normal web links I now use:
=HYPERLINK($GeneralInformation.A1)

I have been trying to do this for Email Links but don’t want the “mailto:” text showing.
Since I’m a very lazy boy and only want to fill in a email address once, I made a small workaround:

*In the General Information Cell A1 I place the desired email (For example ken@mail.com)
*In the General Information Page Cell A2 I put the following command: =CONCAT(“mailto:”,A1)
This automatically creates the desired link that I need for my Hyperlink (mailto:ken@mail.com).
*In my following sheets Use the Hyperlink command to create the hyperlink made up of both A1 and A2
=HYPERLINK($‘General Information’.A1,$‘General Information’.A2)

Thanks for your time and I hope this will help someone someday.

[Lupp]

Also read the help concerning HYPERRLINK() and consider the usage of the second parameter.
Many hyperlinks contain a colon separating a FirstPart from the rest. the rest may then begin with a chosen name (like after mailto: or -in case of http:, https: or even file: with 2 or 3) slashes.