Created attachment 123843 [details] File contains a brief example suitable to produce the bug. Example of the bug including description in the attached file. If I cut a column and paste it to another sheet in the same file corresponding formulas will change but they do not reflect the paste-to-new-sheet operation and their displayed result will not change. Recalculating all cells with F9 does not bring up a different result. If I edit one of these cells and do NOT change anything, but just enter a trailing blank, the cell will be recalculated and display a different result. If I restore the status quo ante with CTRL-Z, the formulas are NOT changed back to their original content, which is a source for possible miscalculations the user may overlook. "The expected result of the cut/paste-operation would be that the formulas would reflect the new location of the pasted cells or they would change to an error (#REF or #DIV/0 or similar)" If you however assign names to the cut cells, and use it in the formulas, all works well.
Hello Thomas, Thank you for reporting this bug, Unable to confirm on 5.0.2 Ubuntu 15.10 or 5.0.2.alpha same OS. Could you please test it on a newer version of LO? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested info is provided.
Hello Usama, Thanks for the quick reply and you are correct! The behaviour is not reproducible on two newer versions of LO. I tested on 5.0.5.2 on Windows 7 and the references to the other sheet are correct. I also installed 5.1.1.3 on Ubuntu 14.04 LTS and the bug does not show either. Nonetheless I do strongly believe that it should be adressed, as 4.2.8.2 is the official LO-version of by Ubuntu 14.04, which is a LTS-version and thus widely used and it will be supported until 2019.
(In reply to Thomas Wailersbacher from comment #2) > Nonetheless I do strongly believe that it should be adressed, as 4.2.8.2 is > the official LO-version of by Ubuntu 14.04, which is a LTS-version and thus > widely used and it will be supported until 2019. It is up to the Ubuntu folks to provide a patch. You can open an issue on Ubuntu Launchpad, if you wish Even 4.4 is already end of life: https://wiki.documentfoundation.org/ReleasePlan/4.4#End_of_Life Closing as WFM.