Hi
Is it possible to set the type of decimal and thousand separator in number and Currency columns?
Previous in the grid it seems to have used the web browser locale (our tests are done in Chrome and Edge) to set this, and we got the wanted type for our users. But now it seems to use US setting with comma as thousand and "." as decimal separator.
Is there any changes done, or is it possible for us to set it to our wanted type for a column?
Regards
Bård
Hi @Bård Indredavik
First of all can you please tell us the OutSystems Data Grid versions on each screenshot and share the oml with that implementation (only the Grid, not the whole module)? I'm asking this because you can have OutSystems Data Grid versions that use different versions of the Wijmo Flexgrid.
The Currency Column doesn't have the thousand separator option and the Number column has the option HasThousandSeparator, not the symbol.By default, the OutSystems Data Grid uses the same formats from the underlying provider that in this case Wijmo Flexgrid, so for better reference you can check their documentation.
If you want to change something you can that look for instance at this page where you can see the globalization formats that you can apply to OutSystems Data Grid by adding the following script to the Grid Initialize event:
OutSystems.GridAPI.ColumnManager.GetColumnById($parameters.YourColumnId).provider.format = "n 5";
Cheers,GM
Thank you for the answer and format setting tip. We reinstalled the latest Data Grid version and now it is back to the previous and wanted behavior.