I’d like to create hyperlinks to specific cells in a sheet in the same document from another sheet in that same document. Is there a way to write the link without Calc ridiculously insisting on using the entire system path every single time so the file can be opened and all the links work regardless of where it’s located on a hard drive? It’s in the same document.
For example I want to create a hyperlink in sheet2 that links cell A20 in sheet1.
=hyperlink($Sheet1.A20, “click”)
Throws an error.
How do I do that without Calc insisting the link is the full file path on my system??
Not everyone is going to save this file after they download it to the same exact file location. There’s a very slim chance they’re going to have the same exact windows username I have.