Filter column with excel type filter

[Catalina Vatuiu]

Hello,

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. 

Thank you,

Catalina

[Ragavee U S]

Hi Catalina, 

We are sorry but the issue is not reproduced at our end. We have created a sample for your reference, which can be downloaded from the below location. 

http://www.syncfusion.com/downloads/support/forum/124191/ze/Sample676499222 

Please try the above sample and if you are still facing any issues, please share below details 

1.       Product version that you are currently working on 

2.       Adaptor that you are using in Grid control for data binding. 

3.       Code snippets corresponding to grid rendering  

4.       If possible, please reproduce the issue in the above provided sample and share. 

Regards, 

Ragavee U S. 

[Catalina Vatuiu]

After updating the syncfusion controls to the latest version, the problem has been solved.

[Gowthami V]

Hi Catalina, 

  

We are happy to hear that your issue has been resolved. 

  

Get back to us if you need further assistance. 

  

Regards, 

  

Gowthami V.