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.
