Formula becoming mashed during sheet copy [closed]

asked 2016-08-12 18:31:52 +0200

jamesb gravatar image

updated 2020-08-31 19:30:28 +0200

Alex Kemp gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-31 19:30:43.216577

Comments

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

jamesb gravatar imagejamesb ( 2016-08-14 19:45:45 +0200 )edit