Change decimal separator

Is there a way to set the local preferences to English and change only the decimal separator into a"," and your grouping separator into a “.”?

Yep, you can do so with the preferences…

I though so, but it doesn’t help. What do I wrong?

Here is a screenshot of my prefs.

Did you perform a reset?

It should work.
What definitely works is setting these in your os prefs.

Marcel,

thanks for your answer

I did, I restartes Servoy, and my OS prefs are set to Dutch format, but I still can’t insert a number with a decimal as a “,”.

Are you formatting your input fields?

I’ve tried both, no go.

Well, it was not meant as an advise but when you use formatting you should still set the format to something like #,###.00 if I am correct.

What happens when you set your locale to Dutch instead of English?

That’s the point, then it works fine, but I want to have al my menus and text in english. I thought there was a way to change the local-english style to accept “,”.

Hmm I guess not many people do that otherwise it would have been recognized as a bug (if it is).

I’m a beginner with Servoy but I just can’t belive that it’s not possible, in all other programs you just set you OS prefs right and adjust the field format and it is working.

Hi Irene, and if you set the seperator in your OS prefs to a comma?
As far as I know, the field format is dependant on your system locale, so if you set your OS to English and adjust the separator to a comma (which I think is wrong IMHO ;-) ) than Servoy should take it over.

Hello Harjo,

it is set to a coma.

hmmm, yes indeed.
Don’t know than.

Hi Irene,

I’m sorry to say this can not be done.
You’re stuck with the thousand- and decimal separators of the locale you select.

Here is a trick to get what you want though: set your locale to francais (Belgique); the number format is as you desire and since there is no French translation yet, you get everything in English :)

Hi Sandor,

Thanks for the work-around, it works fine.

I still think that it’s weird that such a simple thing can’t be done in Servoy, may be an idea for the next version…? :P

Same problem here.

I got an , (comma) when I typ a . (dot).

The problem is that I get the right character in word at the same time. We never had this problem, but it appeared at a certain release.

Because the word comparison I think I can conclude that it must be a Servoy issue. I commente all the set locales of i18n, so only the Servoy local is set.

I tried restart, but it wouldn’t help. As far as I testedd it only happens with the . and , otherwise it could be a ctrl-shift issue.

which locale do you have set in Servoy?

it only happens with the . on the numpad right?
if you set the locale to NL inside Servoy this is right behaviour. (changed in the latest 3.5 version)

try for example this in Excel, you will get an , also there!

Hmm, ok

I have the locale in servoy on NL indeed, but in excel and word it does work. I get a comma for a comma and a dot for a dot.

oke now I’m a bit confused!
what dot do you mean? the dot on the numpad? or the dot on the keyboard itself?