I’m facing an issue concerning GridWeb (v18.2) date cell format when culture is dynamically changed.
You will find here a sample project which will help you to reproduce the issue :
Consider my environment as follow :
- OS : Window7 French
- IE 11 (French version)
When I execute the project, the default culture is French because my OS/browser is in french. So the A1 cell displays the date in the format dd/mm/aaaa which is correct. When I click on the A1 cell to switch to edit mode, the date keep the correct format dd/mm/aaaa.
Now I click on the button “Set US Culture”. This will change the culture to ENG and then reload the workbook. The A1 cell displays the date format like this : mm/dd/aaaa which is also correct. However when I click on the A1 cell to switch to edit mode the date format is changed to dd/mm/aaaa which is not correct because my culture is ENG.