Ask Your Question
0

"filtering by label (tag)" in calc

asked 2015-07-27 22:14:51 +0100

Kioturt12 gravatar image

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2015-07-28 15:25:45 +0100

pierre-yves samyn gravatar image

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.

screenshot

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 :

  • Open bug.ods
  • Select e.g. Calc in the listbox (B3)
  • Click anywhere in the range A8:F18, then Data Refresh Range, the results are updated in B23

Regards

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2015-07-27 22:14:51 +0100

Seen: 560 times

Last updated: Jul 28 '15