Bug 80502 - FILTER: Lost autofilter when sorting
Summary: FILTER: Lost autofilter when sorting
Status: RESOLVED DUPLICATE of bug 77479
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Keywords: possibleRegression
Depends on:
Reported: 2014-06-24 22:05 UTC by Robert Gonzalez MX
Modified: 2015-12-15 10:57 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:

Test data, is a table with some fields with autofilter applied (205.99 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-06-24 22:05 UTC, Robert Gonzalez MX

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Gonzalez MX 2014-06-24 22:05:29 UTC
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 and with LO and LO 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: release
Last worked in: release
Comment 1 raal 2014-09-20 06:21:54 UTC
I can reproduce with Version:
Build ID: 6ee5be0e1dc300120439c3579430d35e7d31131c
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-09-17_10:09:07
Comment 2 Jean-Baptiste Faure 2014-10-12 06:56:45 UTC
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 ***
Comment 3 Robinson Tryon (qubit) 2015-12-15 10:57:48 UTC
Migrating Whiteboard tags to Keywords: (possibleRegression)