Formula Column doesn't filter

Tags: #<Tag:0x00007efc6bbfca48>
#1

Hi ,

I had created formula column, i am not able to filter that column using inbuilt filter drop-downs of handsontable, refer attached file please guide if i missed something

FormulaColumnFilter.PNG1047×364 10.2 KB

The column filters do not refresh the formulas
#2

Hi @viral.mehta

Here https://jsfiddle.net/handsoncode/yhzgtLb0/ I have a demo that we can work on. As you can see it shows the 6030 (my SUM in cell A1) in the filter_by_value list. If I uncheck it it doesn’t show this row in the table.
Can you fill the example out with your settings? It looks like something is blocking the filtering if the rows do not want to get filtered out.

#3

Hello Aleksandra,

in your jsFiddle, if you filter with 6030 which is value of sum=SUM(A2:A4), Handsontabl won’t filter. Please find attached image, and in my scenario entire column’s cells have only formulas , i will check the checkbox any value in column which is basically formula applied on it. hope this give you more clarity

Filter_Issue.PNG1067×578 41.7 KB

#4

Ah Ok… Sorry, I was doing the opposite. You’re right! The table becomes empty. I will investigate it and let you know my thoughts.

#5

Hello Aleksandra,

Any update for this issue?

#6

Unfortunately, I haven’t found anything that can be used as a workaround.

#7

I have reported the issue at https://github.com/handsontable/handsontable/issues/5455
It is the best way to track the changes

#8

This issue was solved in v.12.0.0.

#9