setFilter method not working properly

jspreadsheet / pro

Jspreadsheet Pro | The javascript spreadsheet

https://jspreadsheet.com/

15 stars 1 forks source link

setFilter method not working properly #335

Closed ryouchi84 closed 3 months ago

ryouchi84 commented 3 months ago

Since version 11.4.9 forward, the setFilter method is hiding all the rows in my spreadsheet. I tried giving it one valid value, a partial list of values and all the values from the column, it just hides all the rows. If I call resetFilters I can see all the rows again.

ryouchi84 commented 3 months ago

Here is a short script to see the issue.

https://jsfiddle.net/r8bvt510/

hodeware commented 3 months ago

There is a patch available on the NPM to deal with that.

11.4.12

setFilter forces an array of strings to lowercase;
Applying a filter on load forces the array of strings to lowercase;
Consider null as blank during filtering;
Fix data grid filter position when using nestedHeaders with frozenColumn;