| Summary: | Filtering rows and columns in 2 dimensions | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Jérôme <jerome.bouat> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | ||
| Severity: | enhancement | CC: | heiko.tietze, ilmari.lauhakangas, jerome.bouat, newbie-02 |
| Priority: | medium | ||
| Version: | 5.1.6.2 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | 82662 | ||
| Bug Blocks: | 109326 | ||
|
Description
Jérôme
2016-10-28 08:00:42 UTC
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. |