For some strange reason we have noticed that if we click on Filter and the first line (under the line we click filter) has no data, filer will not work correctly. Sometime we have to place a dot.
What is the cause and how can we get filter working correctly?
Is it possible to just click the row to filter and have everything under it included within filter? (without the need of select all the area)
We ask this because most of the times, the select area has a lot of columns which obviously are not displayed on screen unless scrolling to them. Selecting is a somewhat tedious.