https://bugs.documentfoundation.org/show_bug.cgi?id=160956
Bug ID: 160956
Summary: a filter for rows?
Product: LibreOffice
Version: 24.2.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: j22...@gmail.com
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).
--
You are receiving this mail because:
You are the assignee for the bug.
