https://bugs.documentfoundation.org/show_bug.cgi?id=169587
--- Comment #2 from Colin <[email protected]> --- (In reply to m_a_riosv from comment #1) > Created attachment 204181 [details] > Screenshot of criterias for standar filter. > > What others do you need? My bad: I suspect I used the wrong word - "Condition" was not meant to imply the list of potential derivatives available in the column [Condition] but the matrix of 8 rows of criteria: [Operator] [Field name] [Condition] [Value] [X] [Operator] [Field name] [Condition] [Value] [X] [Operator] [Field name] [Condition] [Value] [X] [Operator] [Field name] [Condition] [Value] [X] [Operator] [Field name] [Condition] [Value] [X] [Operator] [Field name] [Condition] [Value] [X] [Operator] [Field name] [Condition] [Value] [X] [Operator] [Field name] [Condition] [Value] [X] I was suggesting the panel could provide a few more rows to support a scenario where many more than 8 Conditions would be useful. Some of my sheets have 70000+ Rows x 30 Columns, dating back to 2008. My only workaround is to partially filter, copy/paste special the result as "values only" to a scratch sheet and apply additional filters to the scratch sheet. I realise it would be unworkable to have unlimited rows but I assume that making the panel a "rolodex" with some limits could benefit many users -- You are receiving this mail because: You are the assignee for the bug.
