Created attachment 110326 [details]
Sample file to test bug in action
Libre Office Calc
Functions are loosing the reference on adjusted Sheet after modification of data on that Sheet. This problem make almost impossible to use functions for inter-sheet calculations.
I have two sheets in my spreadsheet document. One sheet "Sheet1" whith raw numerical data, another sheet "Sheet2" with functions, that use the data from Sheet1.
I wrote function in cell A2 of Sheet2
Then I drugged data on Sheet1 from cell A1 to cell A6.
After this the function on Sheet2 appeared as:
Attachment is the file from example before modification of Sheet1. To see bug in action you need just to check the original function on Sheet2; drug and drop the cell data on Sheet1 and then again check Sheet2 functions.
forgive my ignorance, I am not a heavy calc user...when you say drug (drag?) and drop how do you actually achieve this?
I tried to highlight a cell and use the mouse to drag to a separate cell but this did not work.
If you could enlighten me regarding keystrokes it would be appreciated (and add to my education)
Just try to drag selection of several cells (the bug will pertsit too). Or try to select two cells and then shrink the selection to a single cell. After this you will be able to drag and drop single cell.
I can not confirm with Version: 220.127.116.11.alpha0+
Build ID: 90fe751ab381cf59e87b79d921b3773567774af2
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-11-27_06:13:34
i can not confirm with Version: 18.104.22.168.0+
Build ID: 9e57326acebde972df22ea4368b5ce4822d51330
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-3, Time: 2014-11-27_12:21:59
Sheet2.a1 = Sheet1.A6+Sheet1.B1
It's fixed in 4.3 version of LO.
Duplicate of bug 79441.
Best regards. JBF
*** This bug has been marked as a duplicate of bug 79441 ***