The auto filter currently provides a button on each cell of the first line of the filtered array. Next the lines are filtered. I would appreciated the transposed form : a button on each cell of the first column of the filtered array. Next the columns would be filtered (all lines would be displayed.
To clarify, the bug reporter is requesting the feature to add auto filter to the data in the form below: (labels are on column A, not on row 1) A B C D E F 1 ID 01 02 03 04 05 2 NAME Andy Bob Candy Emily Fansy 3 Age 23 23 40 43 40 4 City BJ SH NJ BJ BJ
When bug 107348 is fixed, transposing of filtered rows could be a workaround in some cases.
*** Bug 160956 has been marked as a duplicate of this bug. ***
(In reply to m_a_riosv from comment #3) > *** Bug 160956 has been marked as a duplicate of this bug. *** I am not proposing exactly the same. The case mentioned by Kevin Sup in 2016 does not really need a filter in rows: it can be solved by simply pivoting the table and then applying the traditional column filters. Rather, I am proposing something different: add filters to rows just like the column filters. I expand below. 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 This is what I explained in https://bugs.documentfoundation.org/show_bug.cgi?id=160956#c0