After updating from 184.108.40.206 to 220.127.116.11, all formulas changed by adding sheet name before cell reference. For example formula "=A1+B1" changed to "=Sheet1!A1 + Sheet1!B1".
Additionally, some formatting styles are broken in cells.
I suspect that it happened only on ODS files that was converted from XLSX files.
I can not reproduce - created file in version 5.0, when I open in 5.2 the formula is still "=A1+B1". Please send us a sample document, as this makes it easier for us to verify the bug.
I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document.
(Please note that the attachment will be public, remove any sensitive information before attaching it.)
How can I eliminate confidential data from a sample document?
Unfortunately I can't reproduce it now, because I saved document with new version of LO. But I'm sure that formulas haven't Sheet names before cell references when I was opened and used it with LO 5.0.3.
I noticed it happening in my document, unfortunately I was unable to pinpoint (so far) when it happens. I keeps happening from time to time - maybe it happens on Calc updates?
For example it happened during using
Build ID: 1:5.1.0~rc3-0ubuntu1~trusty0
CPU Threads: 2; OS Version: Linux 3.13; UI Render: default;
Locale: pl-PL (en_US.UTF-8)
maybe on upgrade from earlier version?
How can I check whatever my file was in the past a XLSX file?
Created attachment 125418 [details]
File with the bug
There was such bug adding the sheet name to each reference but it's long fixed. Once stored to file there's nothing we could do in more recent release to remove such because the user could had added them on purpose.
I'm sorry, I think the problem is not due to a change of version.
I don't know how, obviously, and I don't kwon when, but sometimes when I reopen a file the formulas have changed by adding the sheet name before any cell reference.
I reproduced the problem many times during my life, in many Libre Office versions.
Currently, I'm using 18.104.22.168 in Ubuntu 16.04.3 but the problem also happened to me under Windows in many versions.
And this problem happens to me suddenly and twice a month at least (every day I work with many spreadsheet files)
It seems a silly question, but when happens, the reading and tracking of the formulas becomes very complicated.
My "solution" is always find the name of sheet and replace by nothing but when the file has many sheets it's heavy and annoying. Quite annoying, certainly.
I will appreciate reopen the bug in order to find a final solution.