We can confirm that the observed is a bug in the Spreadsheet column filtering functionality. Here you will find the GitHub item
, where you could track the bug status.
Keep in mind, that at this stage, I won't be able to offer you a viable workaround for the reported issue.
Also, as a small token of gratitude for reporting to us this bug, I have updated your Telerik points.
Concerning the reverse scenario (first filter by condition, then by value), the condition section is cleared because the value filtering in this case simply narrows down the searched items. For example, on the Demo sample
, if the filtering condition would display all clients with Name containing "am
", the Spreadsheet will display five lines for Samuel Green
and for James Smith.
Then, if the filter by value is set to only Samuel Green
, this filter will always display only two lines, no matter if the Contains condition filter is set or not.
This is also the way how the same functionality works in Excel. After applying the Value filter, the Contains filter is cleared. Please, let me know if I miss something in this specific scenario.