File link in Calc cell

[Mycroft1]

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)

[GrahamLees]

Not sure you are doing this right.

Insert ⇒ Hyperlink ⇒ Path select the Open File at the end of that line to pick the document you want.
After doing so, to open the document use Ctrl-click that should allow you to choose the application to open the file with.