Javascript Error With ExcelFilter

Webix JS
#1

I have a datatable that is using ExcelFilter. It has a series of text fields for filtering. Some of the text fields filter fine, but some throw the following error when I attempt to do a “contains”. My guess is that it doesn’t like something about the actual text in those particular columns.

NOTE: The “task” column works fine. But check out the “Item” column. That does not work.

2021-10-27_14-50-34
2021-10-27_14-50-341920×781 147 KB

Enclosed:

  1. Image with error in JS code

Here is the code to generate the table.

#2

Filter expects that values will be strings, and it seems not to be true
By any chance, do you have null values for some cells in this column ?

#3

It should be all text but I will double check my data. Makes sense. It works on some columns and not others so it must be a data issue for those specific columns. Will report back.

#4

That was it. I had some “null” values and that confused the javascript filtering. I modified them to “” and it worked.