Created attachment 123009 [details]
Access to the "standard filter" (which is rather an overview of the current setup) is possible from the autofilter overlay widget or via menu: data > more filters > standard filter.
1. The dialog has no means to remove rows. So when you want to configure the filter it cannot be done here (although it is possible to add more filters). Likely the row is not applied when field name is "-none-". I suggest to add buttons to add new and delete exisiting filters.
2. The dialog is badly sized and cannot made smaller (running on LibO fresh on KDE).
3. When the current filter contains of many lengthy items, which can easily happen for text, the value input grows to a length above real screen estate. I suggest to cut the text with ellipsis.
4. The OR condition is questionable since OR usually requires brackets. The evaluationn of <foo> AND <bar> OR <baz> AND <qux> is not straightforward. Dropping OR would be the easiest solution. But probably not the best.
one issue, one bug. This should be splitted.
1 - yes, enhancement
2 - WFM, ubuntu Unity. The dialog has minimal size, but can be sized.
3 - Confirm. bug.
4 - Disagree, delete "OR" is lost of functionality. Also needed for compatibility with excel.
Two sub tasks created, OR discussion could run here. Forward to ux-advice...
Issue 1: bug 98239
Issue 2 and 3: bug 98240
We're replacing our use of the 'ux-advise' component with a keyword:
Component -> LibreOffice
Add Keyword: needsUXEval
Description does not meet minimum requirements of QA.