Bug 103548 - Filtering rows and columns in 2 dimensions
Summary: Filtering rows and columns in 2 dimensions
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on: 82662
Blocks: Data-Filter
  Show dependency treegraph
Reported: 2016-10-28 08:00 UTC by Jérôme
Modified: 2020-05-11 07:18 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Jérôme 2016-10-28 08:00:42 UTC
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).
Comment 1 Buovjaga 2016-11-15 12:26:39 UTC
Seems legit -> NEW
Comment 2 b. 2020-05-10 14:43:38 UTC
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 ...
Comment 3 Jérôme 2020-05-10 15:06:34 UTC
The bug #82662 proposes a horizontal filter.
This thread proposes to be able to use vertical and horizontal filters simultaneously.
Comment 4 b. 2020-05-10 22:20:02 UTC
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 ...
Comment 5 Jérôme 2020-05-11 07:18:36 UTC
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.