| Summary: | Sorting problem with cross references | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Erick <erickfis> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | gerard.fargeot, vsfoote |
| Priority: | high | ||
| Version: | 4.3.5.1 rc | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: | https://bugs.freedesktop.org/show_bug.cgi?id=81542 | ||
| Whiteboard: | target:4.2.8 target:4.3.6 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Simple sheet that reproduces the bug | ||
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 *** |
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.