Hello,
I am trying to set the thousands separator to . instead of comma. I have tried putting the locale to es-ES but it continues to use the comma as separator and when I try to change the locale with a script neither does it let me change it. How could I achieve what I am trying to do?
You aren't the only person having difficulty. See this recent post for Swedish, Spanish and Catalan. [BUG-3267, IGN-11874] Perspective numeric entry field decimal separator.
It would help if you could let us know where you are having this problem (Gateway? Vision component? Perspective component? Report? If a component, any particular one?) and the version of Ignition you are running. Thanks!
it is a table in a perspective component
Thanks. I've added this post to the bug ticket, which will up the priority for a fix.
Ana Maria - just to help with terminology:
- The Table is a Perspective component.
- The Table component is in a Perspective view.
It may help avoid confusion in future questions.
To change the number format in a table component, set the locale to it-IT.
This works perfectly. However, if some numbers still do not display correctly, add a Numeric Input Field to the same view (you can hide it if needed). This triggers an event to switch the number format for all numbers displayed on the screen.
Even with this approach, ensure the locale is set to it-IT, as it seems to be the only locale that works reliably for number formatting in Ignition.