I have 2 applications in AppSheet, one is a copy of the other.
In principle I think they are both exactly the same.
However, today I find that they use a different numerical format (until now they were the same).
I have seen that they have corrected something because sometimes it did not put the decimal separator and now it does (although different formats in each application).
Checked the Sheet tables and the definition in ApPSheet, both are in Spanish.
Does anyone know anything about why this happens?
in case of the second app , where it is displaying incorrect Spanish numeric format, if you are using Google sheet as backend sheet, please try setting all the columns or at least the “Cobrar” to “Plain Text”
Thanks for the suggestion.
The result I get when I change it to Plain Text is even worse. It not only loses the format but also the meaning.
It doesn’t seem like a good option.
It’s also doing something strange to me:
If I edit a data with which this is calculated, the final calculated result is correct (I save it in the Sheet) but it is presented multiplied by 100.
I think it is a problem that my application does not pay attention to the Sheet Location format.
That doesn’t happen if I put it back in numerical format (although it still shows the semicolon changed)
The curious thing is that I work in parallel with two applications (they use different data) and except for an error that I am not aware of, I have them configured in the same way and they behave differently in terms of numerical presentation.
If the data source and the app have the same and proper locale settings, the format should come from your default browser’s language settings. With the Chrome, the preferred language needs to be on the top of that list. It’s not enough if it’s the 2nd one or later
