steps to reproduce
- load the attached file
- insert a column at column "B"
- check the filter dropdown at column "B"
actual result
all filter dropdowns display only visible value instead of all candidate values.
expected
debug info
delete column B in the filtering range also causes this issue.