https://bugs.documentfoundation.org/show_bug.cgi?id=173161
Bug ID: 173161
Summary: AutoFilter is missing cell format specific filtering
options (including "This Week", "Last Week")
Product: LibreOffice
Version: 26.2.4.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When using AutoFilter for a column of data, from the menu I can only pick and
select specific values, filter by condition ("empty", "not empty", "top 10",
"bottom 10"), color sort/filter, or sort by ascending/descending. Excel offers
a greater variety of filtering options for date columns, including options to
filter dates from This Week or Last Week.
While not a necessity, since a workaround is possible by going into "Standard
Filter..." from "Filter by Condition" and chaining together a less than and
greater than evaluation with an AND statement to define a range, this takes
longer, requires entering another menu, and would hardcode the week range and
have to be regularly changed. I understand that having the This Week and Last
Week filtering options would be useful enough to warrant this enhancement.
Furthermore it would also increase the ability for those transitioning from
Excel to adopt the software easier.
Subcomponent: EDITING(?).
Steps to Reproduce:
1. Create a region of cells, for demonstration it makes sense to have columns
of different datatypes.
Example CSV to try:
```
a, b
1, 2026/12/13
2, 2026/12/14
3, 2026/12/15
```
2. Enable AutoFilter on that rectangular region.
3. Open the AutoFilter menu with the newly made button, like normal. No matter
the datatype.
The only filtering enabled with the menu is to pick and choose specific values,
and the other options mentioned in the description; there are no date specific
filtering options such as all dates in "This Week".
Alternatively, create a pivot table with a column date field; when using the
AutoFilter selection button beside the date field name there is similar
limitation in filtering options.
Actual Results:
I can pick and choose specific number values, date values, etc. from the
dropdown. I don't have context specific filtering options such as all dates in
this week, and only have the following common set of Conditional Filters:
"Empty", "Not Empty", "Top 10", "Bottom 10".
Expected Results:
In my specific scenario, I was expecting the availability of This Week and Last
Week, as are available in Excel. While not necessary in my case, a similar
variety of options including monthly and quarterly filters was expected.
Additionally, number format related filters such as quick range selection were
also expected.
Reproducible: Always
User Profile Reset: No
Additional Info:
There are many different datatype-specific quick filtering options in Excel,
implementing all of them would take some time. The main goal of this bug post
was to suggest adding Last Week, This Week, and Next Week options for date
columns and pivot table fields, but obviously there is benefit to be had in
implementing more of the shortcuts.
Version: 26.2.4.2 (X86_64)
Build ID: 0229ac93fcf0d7cbc6376066c6f35021cef002dc
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster;
VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
