https://bugs.documentfoundation.org/show_bug.cgi?id=145179
Bug ID: 145179 Summary: The scope of auto-filter (Ctrl+Shift+L) is not limited to the rows which were selected Product: LibreOffice Version: 7.2.1.2 release Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: 123dev...@gmail.com Description: In LibreOffice Calc, select a set of rows and columns, apply the auto-filter (using Ctrl+Shift+L) and then try to sort; It will sort the remaining rows as well (which were not included while applying auto-filter. Example: Populate data in 4 to 5 columns, consider the first row as the header row, 10 data rows and the last one assumed as the footer row (with totals, average, etc.). Now, select the header row, 10 data rows and create an auto-filter. (Remember: the last / footer row was not selected while creating this auto-filter). Now, try and sort on any column; it will also consider the last row (which was not selected while creating auto-filter) in that sorting! Interestingly, if the last row had some totals or averages, then the whole calculation will go for a toss due to shuffling of rows. :-) Basically, the auto-filter should be applied to only those rows and columns which were selected while creating the auto-filter. Steps to Reproduce: 1. Select a set of rows and columns (excluding the last row, which has auto-calculated fields) and create an auto-filter (Ctrl+Shift+L) 2. Sort on any columns, and it will include the last row as well! Actual Results: Includes the rows which were not selected for auto-filter Expected Results: Only those rows should be selected for auto-filter which were selected Reproducible: Always User Profile Reset: No Additional Info: In MS Excel, they create a filter on only those rows & columns which we select -- You are receiving this mail because: You are the assignee for the bug.