As a complement of bug #82662 I would appreciate a 2 dimensions filter : - a filter of lines (1st line could be the columns titles) - a filter of columns (1st column could be the lines titles).
Seems legit -> NEW
is this a dup of #82662? i've seen snippets in the code 'horizontal autofilter' and having bByRow and bByCol parameters affecting sort and filtering, maybe someone tried something like that?, but looks messed up for .ods/xml files ...
The bug #82662 proposes a horizontal filter. This thread proposes to be able to use vertical and horizontal filters simultaneously.
that's ... challenging ... esp. while existing filters are not 'clean' but have problems with their interactions, with compatibility with Excel, storage in different formats, horizontal autofilters are not implemented, and the question is open how to control the evaluation of, and the access to, filters in one dimension that are 'off screen' due to transverse filters ... unless someone has an important use case for which crossed filters are absolutely necessary I don't see any chance that a developer will take care of it ... in theory one might attempt a multi-step solution, filtering with 'copy output to', transposing that area and applying a second filter ... but my system actually said 'SIGSEV' to such tries, and i've read in other threads that transposing switches off filtering and similar ... small hope ...
What I saw with the users I'm in contact with is that the horizontal filter (bug #82662) would be more used than this feature. I understand that this could be difficult to implement.