Why does the VLOOKUP function does not work with file links?

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?

I cannot reproduce.
need_more_info