Hello! I want to filter data in a spreadsheet. The plan is:
- Click on a row you want to filter at (it remains visual);
- All the others rows get disappeared (or become half-transparent);
- On repeated click all trimmed data gets back.
This feature is similar to the one in Table Visual in Power BI (https://docs.microsoft.com/ru-ru/power-bi/visuals/power-bi-visualization-tables)
And this is the current demo https://jsfiddle.net/n8ahts2u/2/. Here I use trimRows() plugin inside the afterOnCellMouseDown hook. The only difference in this fiddle is, a selected row must delete (trim) itself, but it doesn’t happen, too.