I have a grid and some string columns, for which I've set the filters - FilterType = Excel, no other filter settings.
In the values list there are strings which contain one or more commas (for example the text "Far far away, behind the word mountains, far from the countries Vokalia and Consonantia, there live.").
When I choose this value from the check-box-list, the filter doesn't work and I have no results in the grid.
I checked in debug mode, and I've noticed that the value is split into 3 different strings ("Far far away", " behind the word mountains", " far from the countries Vokalia and Consonantia, there live.").
What is the solution for this problem? How can we filter the data from a grid when it contains the "," character?
The same problem I've discovered with the ";" character.