Filter excel by Datetime

Hi

I have a problem with using the Excel filter by DateTime in my table. When I select a filter type, I then have the search menu disappear. Only the filter type choices remain. To do a new search I have to reload the table. If I look in the browser console I get the attached error. I thought that the problem came from the date formatting but the problem persists without formatting the date.

I attach the code that allows me to generate the table.

Thank's

Quentin


Attachment: Sample_acc5ea3.zip

1 Reply

SK Sujith Kumar Rajkumar Syncfusion Team October 25, 2021 11:50 AM UTC

Hi Quentin, 
 
Greetings from Syncfusion support. 
 
Based on the provided information we could see that you are facing problems on trying to open excel filter when Grid is globalized. We checked the problem from our end but unfortunately were unable to reproduce it as the filter was properly displayed and performed. You can check the below sample for reference, 
 
 
We suspect that the reported problem is occurring because of some culture files not loaded in your application for the loaded culture. So please ensure if you have loaded the following files for the corresponding culture – ['ca-gregorian.json', 'numbers.json', 'currencies.json', 'timeZoneNames.json'] from the required culture present inside the main folder(In your case ‘fr’ folder) and the ['numberingSystems.json''weekData.json'(For calendar rendered on Grid filtering)] files from the supplemental folder to your application. This can be checked in the above shared sample for reference. 
 
More details on globalization can be checked in the below documentation link, 
 
 
If problem still persists then please share us the following information to validate further on this, 
 
  • Share us the culture files present in your application folder for the ‘fr’ culture.
  • Share us the culture related code snippets implemented for the Grid.
  • Let us know how you have referenced the script file for the EJ2 controls in your application.
  • Syncfusion package version used.
  • If possible share us a simple sample to replicate the problem or try reproducing it in the above provided sample.
 
Regards, 
Sujith R 


Loader.
Up arrow icon