[Solved] Create a hyperlink from concatenated data

[dreamquartz]

Hi All,

I have a Calc sheet, for document locations and version control, with a lot of data.
All the documents have moved to a new server, and now all the data in the Calc sheet needs to be updated.
All the document names are hyperlinked to the original location, and now I have created a base cell with the new server location, so that it is easy in the future if documents need to be moved again.
I have concatenated the new base cell with all the basic folder structure information for the documents (these are the folders where the Documents should end up again on the new server).
Now that I have done that, I would like the concatenated cell text to become a hyperlink.
Is this possible, and if so, how to do that?
See attachment

Kind regards,

Dream

[mikele]

Hello,
do you know the Hyperlink() function?
https://help.libreoffice.org/6.3/en-US/ ... _id9959410

[dreamquartz]

Yup,

Know that one, but under Ubuntu 18.04 and LO 6.2.5.2 it seems to be not working.
I have:
Cell_1: 'file:///servername/folder1/folder2/'
Cell_x: 'SpecificDocumentFolder'
Cell_y: 'DocumentCode'
Cell_Result=CONCATENATE(Cell_1,Cell_x,"/",Cell_y) => file:///servername/folder1/folder2/SpecificDocumentFolder/DocumentCode
I want to have the (content of) Cell_Result as a Hyperlink.
Calc does not recognize it, even as it is set to recognize hyperlinks.
So doing Cell_HL1=Hyperlink(Cell_Result) or Cell_HL2=Hyperlink(CONCATENATE(Cell_1,Cell_x,"/",Cell_y)) show both no result.

Dream

[Zizi64]

I have:
Cell_1: 'file:///servername/folder1/folder2/'
Cell_x: 'SpecificDocumentFolder'
Cell_y: 'DocumentCode'
Cell_Result=CONCATENATE(Cell_1,Cell_x,"/",Cell_y) => file:///servername/folder1/folder2/SpecificDocumentFolder/DocumentCode

Please upload a small but real sample file here in an attached .ods file.
Is the DocumentCode a real and existing file name with format "name-dot-extension"?

What is the symptom?
- The result will not become a hyperlink (missing hyperlink formatting properties)
- or the result seems as a hyperlink (it is formatted as a real hyperlink and the mouse cursor change when hoover on the hyperlink) but it does not work...


I am using the HYPERLINK() function to open other document files (ODF-s and PDF-s) from an another PC of our LAN, and it work for me on a Windows/Windows, Windows/NAS4Free relation. I am using LibreOffice 6.1.6., and it worked with LO 4.4.7 too.

[dreamquartz]

I have:
Cell_1: 'file:///servername/folder1/folder2/'
Cell_x: 'SpecificDocumentFolder'
Cell_y: 'DocumentCode'
Cell_Result=CONCATENATE(Cell_1,Cell_x,"/",Cell_y) => file:///servername/folder1/folder2/SpecificDocumentFolder/DocumentCode

Please upload a small but real sample file here in an attached .ods file.
Is the DocumentCode a real and existing file name with format "name-dot-extension"?

What is the symptom?
- The result will not become a hyperlink (missing hyperlink formatting properties)
- or the result seems as a hyperlink (it is formatted as a real hyperlink and the mouse cursor change when hoover on the hyperlink) but it does not work...


I am using the HYPERLINK() function to open other document files (ODF-s and PDF-s) from an another PC of our LAN, and it work for me on a Windows/Windows, Windows/NAS4Free relation. I am using LibreOffice 6.1.6., and it worked with LO 4.4.7 too.

Thanks for your response.
As result of it, I took a closer look at what to do, and it appears to be that, to set it up, it is a bit finicky with LO 6.2.5.2.
You have to be extra careful with doing it the right way, which for my situation was a little more complicated than I thought.

The attachment shows what I cam up with.

If you have any ideas to improve, I would like to hear from you.

For the issue, I consider it SOLVED.
Dream

[Zizi64]

Your HYPERLINK() functions use the string value "Documents" of the cell F2, but not the "file://..." partial URL. It can not work as a real URL. Try to concatenate the string constant "file://..." in the HYPERLINK functions,

[Zizi64]

Yous can extract the URL from a cell containing a hyperlink. (You must use the URL of the "Documents" folder to build your Hyperlinks):

viewtopic.php?t=41295


viewtopic.php?f=21&t=2762