The following function outputs nothing:
=VLOOKUP(“TAG”,‘file:///home/Users/username/otherfile.ods’#$Sheet1.A1:B6,2)
If I open ‘otherfile.ods’ and paste this same formula, it works flawlessly, producing the output I want.
Is there a reason for this to happen or is it just a bug?