Created attachment 110064 [details]
Simple sheet that reproduces the bug
In a spreadsheet with 2 sheets, the first is the database (source) and the second is for sorting as you wish (called references)
The second sheet makes references to the first sheet - all ok.
Now, try to delete some entries in the references sheet and them sort it. Its all broken!
I've created a simple example which demonstrates it:
id, name, age in the source sheet
try referencing and sorting it on the references sheet and you will see.
got this libreoffice from ppa
Build ID: 430m0(Build:1)
because Libreoffice 220.127.116.11 has similar issues as seen on
Adjusted in 4.3, 4.4 4.5 master, and now a final 4.2.8 releases
Pushed to 4-2 as http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-4-2&id=094b19c2759c8ecc88b38d37047e9ac2de9b68ee
Pushed to 4-3 with https://gerrit.libreoffice.org/gitweb?p=core.git;a=commitdiff;h=867c9072b146d3f15b27df6b906d4ac2e3f8bf9f and https://gerrit.libreoffice.org/gitweb?p=core.git;a=commitdiff;h=62a0a299b3c96cb743059d357c51b9c82aa38b98
*** This bug has been marked as a duplicate of bug 79411 ***
*** This bug has been marked as a duplicate of bug 79441 ***