Hi,
Is it possible to create a “filtering by label (tag)” in calc.
I’m writing a sheet that works as a bug tracker (for software programmers) and it would be nice to have a system to link a “label (tag)” to a cell so that, when clicking on it, a filter will be created to show all cells with that label.
Is it possible?
Thanks
Hi
Several possible solutions. In ascending order of actions to perform:
1- Data Filter AutoFilter (see help)
One of the features is Show only the current item, but we must open the drop-down list to access it.
2- Create a database connected to the spreadsheet. Register this database (Tools Options Base Databases).
Such a database can be opened in the View Datasources (F4) . The toolbar contains filter tools including AutoFilter.
3- Data Filter Advanced filter
You can use Data Validity to generate a listbox of tags (see B3 in bugs.ods)
and use it in an advanced filter :
Data Refresh Range, the results are updated in B23Regards