Hello
In Calc, using the following I can, of course, call in data into my current spreadsheet file:
='file:///home/jamesb/Documents/List.ods'#$'R&D'.H22
However, I’d like to be able to reference the last two digits, “22”, from another cell, say A1, in my current spreadsheet file, something like this:
=CONCAT("'file:///home/jamesb/Documents/List.ods'#$'R&D'.H",N(A1))
or
=CONCAT("=","'file:///home/jamesb/Documents/List.ods'#$'R&D'.H",N(A1))
Where the value in cell A1 is “22”.
Unfortunately, as you’ll know, this simply results in a cell displaying the following, but not the data contained in the remote file’s cell:
'file:///home/jamesb/Documents/List.ods'#$'R&D'.H22
The method is eluding me, despite much searching.
I’d be most grateful if someone could help.
Thank you.