Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

LO Calc: relative path to external sheet?

How can I express the following:

'file:///home/mark/Desktop/L4L/Products/material costs.ods'#$Webbing.$C$2:$C$6

as a spreadsheet in the same directory? I.e., no absolute path. Example:

'file://material costs.ods'#$Webbing.$C$2:$C$6

I've tried various things. LO keeps changing it to an absolute path. I have click a different cell and then click back to the one I edited to see how LO reverted it to an absolute path.

The only reason I'd like it to be relative is to make my formula's less tedious. (They're pretty busy-looking with the same path 4-5 times in one formula.).

Thanks in advance.