Filter By Value pre selection

Getting help Questions
1

When the worksheet is loading I want a specific filter value checked .Is it possible ?

2

Hi @linpap
Yes, it’s possible. It can be achieved by the addFormula() method. You can read more about it in our docs: https://docs.handsontable.com/pro/1.5.0/Filters.html#addFormula

example:

hot.getPlugin('filters').addFormula(0, 'begins_with', ["o"])
for arguments addFormula(column, name, args)

3

@aleksandra_budnik Great thanks . I am able to do that

4

Great! Glad I could help.

5

one more question . Say on a cell can i write javascript anyway so it can toggle show/hide few rows ? I see writing HTML is possible but not sure if I can anyway use jscript ?

6

hi @linpap
You can toggle the show/hide state. This example shows how to hide selected rows/columns and how to show all of them http://jsfiddle.net/handsoncode/mr13r2tt/
You can add an ability to show selected rows as well but it will need little more coding as you would need to check if selected row’s index is in the hiddenRows array.