Description
In a multi-column table with filtering, the filter dropdown for any column includes values that have already been hidden via filters in other columns.
As an example, if you have the following table:
| Column A |
Column B |
Column C |
| Alpha |
Foo |
Alice |
| Beta |
Bar |
Bob |
| Gamma |
Baz |
Carol |
If you filter out Beta in Column A, then open the filter-dropdown for Column B, it will show the corresponding value Bar unchecked (i.e. already filtered-out), but checking the checkbox (to unfilter it) does nothing, since the Column A filter still applies.
To make things worse, applying additional filters in another column seems to implicitly add the automatically-unchecked (i.e. filtered in other columns) values to that column's filter, so that even when you re-check them in the original column's filter (to bring them back), they don't re-appear, because the second column also filters them.
As an example, after filtering out Beta in Column A, if you then filter out Foo in column B, and go back to Column A's dropdown and un-filter Beta, that row will not re-appear.
Expected outcome
Values hidden by filters on other columns should be omitted from the filter list entirely.
Minimal reproducible example
https://vaadin.com/docs/latest/components/spreadsheet#tables-filters
Steps to reproduce
Filter some values in Column 1, then open the dropdown for Column 2.
Environment
Vaadin version(s): 25.1
Browsers
Issue is not browser related
Description
In a multi-column table with filtering, the filter dropdown for any column includes values that have already been hidden via filters in other columns.
As an example, if you have the following table:
If you filter out
Betain Column A, then open the filter-dropdown for Column B, it will show the corresponding valueBarunchecked (i.e. already filtered-out), but checking the checkbox (to unfilter it) does nothing, since the Column A filter still applies.To make things worse, applying additional filters in another column seems to implicitly add the automatically-unchecked (i.e. filtered in other columns) values to that column's filter, so that even when you re-check them in the original column's filter (to bring them back), they don't re-appear, because the second column also filters them.
As an example, after filtering out
Betain Column A, if you then filter outFooin column B, and go back to Column A's dropdown and un-filterBeta, that row will not re-appear.Expected outcome
Values hidden by filters on other columns should be omitted from the filter list entirely.
Minimal reproducible example
https://vaadin.com/docs/latest/components/spreadsheet#tables-filters
Steps to reproduce
Filter some values in Column 1, then open the dropdown for Column 2.
Environment
Vaadin version(s): 25.1
Browsers
Issue is not browser related