separator for 1000' and decimal separator issue in demantra and excel export.
We are implementing Demantra in Colombia and we have specific issue in the separator of thousands and decimal separator.
1) In the user's system, the thousands are separated by '.' (dot) and when we export to excel, the '.' is treated as decimal. for example 19,930 gets exported to excel as 19.93.
2) User's system had regional settings as 'Language as Espanol (Colombia). We tried control Panel --> Region and language, set the language to 'English United states' and validated in the screen that it shows 1000 seperator as ',' (comma) and decimal separator as '.'(dot) and restarted the system.