In previous version of Servoy, if you specify a field format in design mode, it will overwrite any of the User or Server preferences for the default number format. However that seems to not be working exactly right in 4.x. For example, when I specify the format “¤#.00” in design mode on a field, for all US users, it displays correctly, like $1.00. However french users are seeing a coma instead of a period. So, they see $1,00.
Is this a change in default behavior, or a bug? I even tested this in developer on the french locale. Developer shows the correct format, but the debug client still shows the comma instead of the period separating the dollars and cents.
Version: 4.1.4 - build 681
Hi Scott,
As far as I know France (and the rest of Europe) uses the comma as a delimiter. So one thousand dollars is formated $1.000,00.
Not sure about Canadian french though.
right, this example is Canadian French. But either way, if I specify a period for the delimiter in design mode, it should work no matter what the client locale is.
No, the dot in the format “¤#.00” means the current decimal delimiter based on locale, maybe there is some way to escape it to have a simple dot.
nicola is right. the format you specify is the format all developers do use. thats the standard format but in the client this is translated to how the Locale of the user has that configured
so you dont say with the format that it has to be a . there and a , there, they are only place holders.
You cant override this (besides setting the locale)