Bug 160956 - a filter for rows?
Summary: a filter for rows?
Status: RESOLVED DUPLICATE of bug 82662
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.2.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-05-06 11:16 UTC by J22Gim
Modified: 2024-05-08 16:27 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description J22Gim 2024-05-06 11:16:48 UTC
Description:
Enhancement

In Calc, you can set a filter to each column. The filter determines which cells are shown below, based on their contents. This gives you a nice flexibility to show data that fits some criteria. But one could argue we are using only half of the possible flexibility: Why not use filters also on the rows? Then we would use the full possibilities of a 2D table (spreadsheet).

Steps to Reproduce:
Imagine we have a spreadsheet with countries as columns, and different characteristics of each country as rows (population, surface area, CO2 emissions, etc).

Actual Results:
Using the traditional column filters, we can order them by population, or only show the ones that are below 300 km2 in surface area).

But what if, besides those two filters, I want to only show the countries with a GDP higher than 300000 M USD? and why if I want to show first (to the left) the ones with less CO2 emissions (ie, order them using CO2 emissions values)? 

Expected Results:
This could be done by opening the possibility of using filters on the columns. As far as I imagine, this does not interfere with any filter applied to the columns. In my example above, the filtered table will show the countries ordered by population (column filter), only show countries with less than 300 in the 'surface area' (column filter), only show countries with GDP higher than 300000 M USD of GDP (row filter), and ordered from left to right according to their (ascending) CO2 emissions (row filter).


Reproducible: Always


User Profile Reset: No

Additional Info:
One could argue that the column filters are not really designed for this, but for the cases where the table is pivoted: indicators such as population should be columns, and the countries are the rows. However, if you pivoted the table and apply column filters you would still not be able to reach the same final result as described above.

If adding filters to rows is not an option, then another way to improve flexibility is to add the option in the 'standard' filter, where one can add many conditions. Simply use the rows as available variables (maybe adding a tickmark that the first column is the row header).
Comment 1 m_a_riosv 2024-05-06 12:15:15 UTC

*** This bug has been marked as a duplicate of bug 82662 ***
Comment 2 Jérôme 2024-05-08 16:27:10 UTC
Hello J22Gim.

Maybe the quite unlimited number of filters of the pivot table would fit your need :
https://help.libreoffice.org/latest/en-US/text/scalc/guide/datapilot_filtertable.html

?