Number formating in table

Ignition
1

I have a problem I can't find a good solution for. I have some tables that get data from a database with a named query. The data in the database is in Swedish format but in Perspective the number for TRANSPORT is presented in US format.

image
image939×201 7.16 KB

How do I change this? I can't do it in the property editor under column and number format since this is not changing the format. The named query returns the data in US format and I use a script transfrorm in the data binding for the colors on the rows.
image
image306×233 7.66 KB

2

I'm running a version 8.1.35 and there is a bug with loading the locale from the browser.

Solution that works for me:
Place a numeric entry field somewhere on the same view. (you can give it visible false if you dont want to have it there).

1 Like
3

Related: [BUG 7305] Perspective Table Number format not changing according to the selected Locale.

2 Likes
4

(post deleted by author)