Formula becoming mashed during sheet copy

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

jamesb 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 close merge delete

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