Formula becoming mashed during sheet copy

[jamesb]

Help/About says I’m using LibreOffice 5:

Version: 5.2.0.4 Build ID:
066b007f5ebcc236395c7d282ba488bca6720265
CPU Threads: 2; OS Version: Linux
3.10; UI Render: default; Locale: en-GB (en_GB.UTF-8)

I wonder if anyone else has had this experience:

I have this formula in a cell in a sheet:

=MATCH(B2,‘file:///home/jamesb/Documents/list.ods’#$‘R&D’.B$1:B$1048576,0)

I click and make a copy of it with a new name further down the list of sheets, and the formula becomes mashed to:

=MATCH(B2,‘file:///home/jamesb/Documents/list.ods’#$‘R&D’.B$1:‘file:///home/jamesb/Documents/list.ods’#$DefValue.B$1048576,0)

The sheets “R&D” and “DefValue” both exist in the remote file, and in that order. Is there something I’ve got wrong?

Thanks.

[jamesb]

Strangely, today after opening my sheets afresh, the problem seems to have gone away. No. I can’t figure it out either!