Handsontable filter details not updating

Tags: #<Tag:0x00007efc6503b9a8>
#1

I have a table with custom summary row at the top row. Whenever the changes are made in the grid to the specific cell range - recalculates and loaded to the table. If someone filtered then it takes the visible rows and recalculate and applied to the filter. Since i m doing the loaddata on changes or filter… the table looses actual filter which was chosen initially.

Is there a way to actually to update the filter items based on the latest grid data with previous filter details ?

#2

Hi @shivaraj.durairaj

the current filter by value list is not adjustable. It gets all the data from what we can see by calling getData method.

What you can do is saving the state of the filter via afterFilter hook and load it again using afterLoadData hook and the addCondition method.

#3