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 4.2.7.2 has similar issues as seen on https://bugs.freedesktop.org/show_bug.cgi?id=86125
Recurrent error. https://bugs.freedesktop.org/show_bug.cgi?id=70815
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=79441 https://bugs.freedesktop.org/show_bug.cgi?id=81542
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 ***