# Error with number format in perspective table

**URL:** <https://forum.inductiveautomation.com/t/error-with-number-format-in-perspective-table/86593>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [February 29, 2024, 10:57am UTC](https://forum.inductiveautomation.com/t/error-with-number-format-in-perspective-table/86593 "2024-02-29T10:57:48Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Flavia\_Delli](https://avatars.discourse-cdn.com/v4/letter/f/f17d59/32.png) [@Flavia\_Delli](https://forum.inductiveautomation.com/u/Flavia_Delli)\
**Post date:** [February 29, 2024, 10:57am UTC](https://forum.inductiveautomation.com/t/error-with-number-format-in-perspective-table/86593/1 "2024-02-29T10:57:48Z")

</div>

Hello,  
I'm on ignition 8.1.31.  
I have a table with float numbers that have to follow the locale format.  
Example:  
en-US -\> 1,000.5  
it-IT -\> 1.000,5  
At this moment even if I change the locale in the perspective session properties it always shows the en-US format.  
What should I do to avoid this behavior?  
I need to see the italian format if the project or the session locale is it-IT.

 ![issue format number](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/8/181c7a3d91a526c254bea25f38fc200b00b8c35d.png)

Thank you,  
Flavia Delli

---

<div class="post-metadata">

**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\
**Post date:** [February 29, 2024, 4:24pm UTC](https://forum.inductiveautomation.com/t/error-with-number-format-in-perspective-table/86593/2 "2024-02-29T16:24:42Z")

</div>

It's hard to tell exactly what the screenshot is displaying, but that locale formatting looks correct to me.

`en-US`:  
 ![Screenshot 2024-02-29 at 8.22.49 AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/9/295eb84505b510358417100692f729936453e3ed.png)

`it-IT`:  
 ![Screenshot 2024-02-29 at 8.22.57 AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/c/2ce2a2c5412db7ec225ef284e2cb3c84f88990aa.png)

---

<div class="post-metadata">

**Author:** ![Flavia\_Delli](https://avatars.discourse-cdn.com/v4/letter/f/f17d59/32.png) [@Flavia\_Delli](https://forum.inductiveautomation.com/u/Flavia_Delli)\
**Post date:** [March 1, 2024, 9:47am UTC](https://forum.inductiveautomation.com/t/error-with-number-format-in-perspective-table/86593/3 "2024-03-01T09:47:57Z")

</div>

![table locale it](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/e/ae61e4a983e6477f5c9759c784aa6da0887695a5.png)  
 ![table locale](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/d/7d7a0453e7feb2e2a1b21c70589f4fe9e33609dd.png)

The screenshots show the original dataset used in the component table, I just dragged and dropped it in to the view .  
As you can see there's the very same behavior.  
On the property the data is shown with the it-IT locale, but in the view is always en-US even changing the Locale.  
(I also tried launching the perspective session and the result is the very same)

Does the windows gateway Region condition this functions?  
Here the region info:

 ![Region](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/c/0c677c2bba4df9043b1594ef996d9e0aaa55eaf9.png)

---

<div class="post-metadata">

**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\
**Post date:** [March 1, 2024, 5:27pm UTC](https://forum.inductiveautomation.com/t/error-with-number-format-in-perspective-table/86593/4 "2024-03-01T17:27:35Z")

</div>

Apologies. After using 8.1.31, I see there is indeed something wrong. To my knowledge we've not worked any tickets which would have "repaired" this unexpected behavior, yet it works for me in newer versions. I'm working with the relevant team to determine what could have fixed this and what version that would have occurred in.

---

<div class="post-metadata">

**Author:** ![illank86](https://avatars.discourse-cdn.com/v4/letter/i/c77e96/32.png) [@illank86](https://forum.inductiveautomation.com/u/illank86)\
**Post date:** [September 19, 2024, 8:24am UTC](https://forum.inductiveautomation.com/t/error-with-number-format-in-perspective-table/86593/5 "2024-09-19T08:24:16Z")

</div>

i have this problem as well, which version this is not a problem?