Posted 8 September 2017, 2:22 pm EST
I'm using Spread for Windows Forms 5 in my application and I would like to modify a few things concerning the filters, but I don't really know how to do it, or even if it is possible... so I hope somebody can give me a hand here!
1) If the column to be filtered has a large number of different values, the Spread takes quite long to generate the item list when the user clicks on the filter icon. Is there any way to limit dynamically the size of the list? I would like to display the entire list only when there are less than 50 different values in the column, otherwise only the common values (all, blanks, non-blanks, etc) should be displayed.
2) When a filter is applied, the user cannot see the rest of the existing values in the list anymore. So if he wants to change the filter he must reset it first, and then select the new desired filtering value. How can I make the list to show always all existing values?
3) I've got a sort and a filter icon in the same cell of the column header, and the sort icon is always displayed on the left of the filter icon. I would like to reverse the order of the icons (filter - left and sort - right)... can this be done?
Thanks in advance for your help, I appreciate it!