Description: If several filters are used in a column (with Auto Filter) and you want to continue filtering with the Standard Filter option (e.g. "Column A" > "0"), the previously set filters are not completely adopted. In a non logical way sometimes a few of them are. But mostly only the first one remains. You could only work with the standard filters. However, the required time would be significantly greater. In the screenshot "Column A" = "1" - "or" [...] "3" - "or" [...] "or" [...] "7" should appear for the standard filter. Steps to Reproduce: 1. Filter for at least two values in a column 2. Open Standard Filter 3. Standard Filter is empty / some values are missing Actual Results: Filters only work individually - Please refer to the attachement Expected Results: Settings are written in both filter functions Reproducible: Always User Profile Reset: Yes Additional Info: Using Standard Filter first, the settings of the columns are right. But continuing using these settings from Auto Filter is leading into wrong results.
Created attachment 169595 [details] Comparison Auto and Standard Filter
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 169614 [details] Filter options set in column A. When opening Standard Filter, there are no settings adopted.
I can see the behaviour as well. Ticking several values in the autofilter menu results in the "Standard Filter..." dialogue only showing the rule for the first value in the list that is ticked. For example: 1. clear the filter on column A ("Clear filter" in LO 7.2 and above) 2. deselect all values (untick "All") 3. tick values 3, 5, 7 4. click "Apply" 5. go to "Standard filter..." for the same column. Result: only the rule "A = 3" is shown. Clicking "OK" results in a filter only showing the value 3. Reproduced with: Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: de7356c2e0cb099fac396808b5a86a0393b48e5f CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-06-14_22:38:17 Calc: threaded and Version: 7.0.6.2 Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded
I am confident we should call this a duplicate of the older Bug 56187 *** This bug has been marked as a duplicate of bug 56187 ***