https://bugs.documentfoundation.org/show_bug.cgi?id=148293
Bug ID: 148293
Summary: Sorting autofilter
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 103512, 108386
Created attachment 179237
--> https://bugs.documentfoundation.org/attachment.cgi?id=179237&action=edit
Sample ODS with filter
When an autofiltered range is sorted using Sort Ascending / Sort Descending,
the following discrepancies happen:
- the filter icon moves along with the first item to its sorted place,
- if the first is a header item, it is included in the sort, while it shouldn't
be.
See the attached sample with a simple autofilter, where the first item, "4" in
A1 is a header in one sheet, and not in the other.
Expectation when sorting:
- when "4" is a header item, it should stay in A1, and the filter as well,
- when "4" is data, it should be sorted, the filter should stay in A1,
- when "4" is data and sort in the filter popup is used, the filter should stay
in A1.
When "4" is a header item and sort in the filter popup is used, both the item
and the filter stays in A1 as expected, unlike the above three cases.
For reference, Excel keeps the filter in its original place when sorting.
Whether first element is kept in place depends on if one only selects the
autofilter area, or the whole column, but I also haven't seen header/data
distinction in Excel, first element is header by default (perhaps there's a
special way to set it as data).
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=103512
[Bug 103512] [META] AutoFilter-related bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108386
[Bug 108386] [META] Calc sorting related bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug.
