Decimal point on numpad

[lwjwillemsen]

Does anyone know how to get the point (.) key on the numpad (US keyboard layout) to act like a komma (,) in number fields in the Servoy Webclient ?
Servoy smart client does it already (hit the point key and a komma appears) and Microsoft Excel also.
It happens in Firefox and Microsoft Internet Explorer.

Servoy 5.2.10

Any help appreciated in taming the keyboard stallion...
Thanks,

[lwjwillemsen]

Anybody in Europe with knowledge of this problem ?

[lwjwillemsen]

We have some Dutch web Client customers who are not too happy about this...
Other Dutch web apps like Rabobank Telebanking do support the numPad decimal key.

1) How do other Dutch ISV's cope with this US keyboard layout issue ?
2) I would expect a Servoy solution to this issue.

Regards,

[jcompagner]

Rabo also just inserts a . when i press the numpad .
what rabo does is if there is 1 . in the entry they just make it a , after you leave the field.
So even if i type:

1.000

it results in

1,00

which i think i a bit wrong..
and it doesn't matter if i type a . through the numpad or by using the 'normal' .

so they have no special support what so ever for that.

[lwjwillemsen]

Hi Johan,

No Support ? I wished we could do that Rabo-trick in the Servoy web client on number fields.

Functionally I can enter on their site a decimal portion in the amount field with only using the (US) numpad and that's the end user need !

Changing all numeric fields on forms to text with extra logic for point-handling does not look like a nice and easy workaround to us...

Please provide a solution...

Regards,

[jcompagner]

i guess what you want is that . or , are both just the same thing?
So some customers type "1,110" and others type "1.110' which is just the same value? (so 1,11 in dutch)

Directly in Servoy you can use converters for that so yes make it a Text column and convert it the way you want from and to a number.

Or maybe somebody can make a plugin for you that attaches a key listener and converts and . to ,

[lwjwillemsen]

Hi Johan,

Thanks for the converter info.

Can you imagine the amount of work that has to be done in case of hundreds of form number fields only for the webclient
for the Smart Client already behaves the (Dutch) way !

Can't the Smart Client numeric input logic be build into the Web Client ?
Should not the smart and web basic key handling be the same ?

Regards,

[jcompagner]

i think that could be possible, because it seems that we can catch the . on the numpad, in javascript we do seem to get a special char code for that.
So make a case so that we can look at it if we can catch that and then insert a , or . depending on the locale of the user.

[lwjwillemsen]

Hi Johan,

There was already a case present in the old support system # 422246. (Not all cases were migrated to JIRA it seems)

Can you pick up it there or shall I enter it again in JIRA ?

Regards,

[jcompagner]

that one was closed (not fixed), and those where not moved to jira only open issues
So make a case in jira so that we can look once more to it.

[lwjwillemsen]

Ok, https://support.servoy.com/browse/SVY-1041

Thanks for looking into it...

Regards,

[Jan Aleman]

Personally I find applications that overwrite my personal preference of using a . for decimal separation (including Rabobank) very annoying. The whole concept of a locale is that a developer respects the preferences of the user and does not impose his own preference on them.

Nevertheless in Servoy you can simply use a converter to do what you want.

[lwjwillemsen]

Hi Jan,

Thanks for your contribution.

We have hundreds of number fields with decimal portion.
Must we extend all those fields with a convertor ? Seems like a lot of work for using the decimal sign on the numpad...
As said before the Servoy Smart Client already supports all those NL people with an US-layout keyboard...

I think I am gonna start a (web)shop who sells keyboards with NL-layout !

Regards,

[lwjwillemsen]

Some extra info :

The convertor datatype must be set to text to intercept the . or , in the global convertor method , => I can't do arithmetic with the number field anymore within Servoy

Regards,