sheet references have been added on all references to the same sheet [closed]

asked 2018-11-15 10:05:25 +0100

biz gravatar image

Using LibreOffice spreadsheet on Ubuntu 16. After a recent update, I find that all internal references within a sheet are prefixed with the sheet name: eg on ThisSheet where I had in C5: "=C3+C4" this have now been changed to "=$'ThisSheet'.C3+$'ThisSheet'.C4". I did not ask for this change to happen... This has made equations cumbersome due to the length of unnecessarily referring to the same sheet. How can I globally remove these unnecessary references?

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by erAck
close date 2018-11-15 17:01:23.768476

Comments

You seem to be using an old version, 5.1.x or such. Please upgrade. See this https://ask.libreoffice.org/en/questi... same question.

erAck gravatar imageerAck ( 2018-11-15 17:01:13 +0100 )edit