Apsheet inteprets comma decimal as thousands

[Milos_Aleksic]

This is the situation I am not able to figure out.

I have a spreadhseet with externally managed data, which stores the numeric value as decimal with a dot as a decimal separator.

That value is used inside Appsheet, due to browser config I see it with a comma as a decimal separator, till now, no problem with that, as everybody will see it based on their config, but the value will still be the same.

The problem rises when I store that value, using appsheet, in a different spreadsheet. It is stored with the comma instead of dot. Now when I read from appsheet that second value, appsheet interprets is thousands, and not decimals…

What I noticed is that the value is stored like that in the form, when creating the record with appsheet, so I assume there is nothing I can do in spreadsheet.

Is there a way I can force it to store it with a dot? Or should I use a differente approach.

Mainly my issue is that 34.5, becomes 3450,00…

I tried to reproduce the issue on a clean app, and was not able, there it was behaving as expected. Any idea what can make it behave that way? I added a screenshot where you can see how appsheet interprets the comma value as thousands.

[SkrOYC]

help.appsheet.com

Localize: The Essentials

Learn what you can do in the Localize section of the UX tab.

[Milos_Aleksic · Accepted solution]

It seems the issue is realted to spreadsheet formatting… Once I set it to have the same format as apsheet was saving the data, all seems to work as expected…