I need to include a clickable link to a file, in a Calc cell.
Is this possible?
If so, I assume that I can use the form:
file:///C:/Folder1/Folder2/File.ext
Is this correct?
There is, however, a further problem.
The name of Folder2 includes a space.
I expected to be able to replace the space with %20
but that doesn’t work, as Calc only sees the string up to (and not including) the space or the %20.
If I remove the space, it still only sees the string up to the same point.
(It works with or without the %2 in a Web browser.)
So, Is there any way to do this?
OS: Windows 11 Version 23H2
LibreOffice version 25.2.4.3 (X86_64)