Created attachment 101701 [details] Test data, is a table with some fields with autofilter applied Problem description: In Calc,the filter applied is lost when changin the sorting, due to change in the number on rows or columns Steps to reproduce: Set Autofilter with Data / Filter / Autofilter Sort by field Folio with Data / Sort Go to the end of the list and copy last 4 rows and paste it at the end Also happens when deleting rows, changing the range Select all table with Shift + ctrl + right arrow then shift + ctrl down arrow Go back to the top with the scroll ball of the mouse or scroll bar Select Data / Sort Observe when the dialog box appears, the filter disappear Only happens when selecting this way If the sorting begins with the auto range of Data / Sort there's no problem I have tested it in Win XP with LO 4.2.5.2 and with LO 4.2.5.2 and LO 4.3.0.1 in Win 8, reproducing the same behaviour. I added two screenshots for better understanding Current behavior: The filter is gone after the re-sorting of data Expected behavior: The filter should stay in place and adapt to the new range of data, wheter there are more o less rows in the sorting range, as the filter adapts in the same way when adding or deleting rows. I found a related bug https://www.libreoffice.org/bugzilla/show_bug.cgi?id=45125, with the problem since LO 3.5 and another https://www.libreoffice.org/bugzilla/show_bug.cgi?id=77479 or LO 3.6.7 Operating System: Windows 8 Version: 4.2.4.2 release Last worked in: 4.2.2.1 release
I can reproduce with Version: 4.4.0.0.alpha0+ Build ID: 6ee5be0e1dc300120439c3579430d35e7d31131c TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-09-17_10:09:07
It is the same problem as the one tracked in bug report 77479. Best regards. JBF *** This bug has been marked as a duplicate of bug 77479 ***
Migrating Whiteboard tags to Keywords: (possibleRegression) [NinjaEdit]