arrghh dot vs comma

[M. Posseth]

Hi ,,

i live in Europe in Europe the decimal seperator is , not a .
why is it so that if i press on my numeric keypad the . a . appears ??

in my opinion it should be a , ( sounds odd but ... it should be so )

my problem :

i work currently in a companny where people do data entry with the numeric
keypad we are rewriting a cobol program ,,, in cobol you could just say
decimal seperator = dot or comma and it would work as expected . how can we
simulate the same thing in .net ??

windows settings are correct ( dutch settings ) , we work with a standard
qwerty international keyboards on all computers

so what i would like is that only the numeric keypad . will give a , as
this is the numeric seperator symbol the keyboards ,. ( the ones below <>
) should work as they do.

someone an idea ???

regards

Michel Posseth

[tomb]

Re: arrghh dot vs comma

M. Posseth wrote:
[color=blue]
>Hi ,,
>
>i live in Europe in Europe the decimal seperator is , not a .
>why is it so that if i press on my numeric keypad the . a . appears ??
>
>in my opinion it should be a , ( sounds odd but ... it should be so )
>
>my problem :
>
>i work currently in a companny where people do data entry with the numeric
>keypad we are rewriting a cobol program ,,, in cobol you could just say
>decimal seperator = dot or comma and it would work as expected . how can we
>simulate the same thing in .net ??
>
>windows settings are correct ( dutch settings ) , we work with a standard
>qwerty international keyboards on all computers
>
>so what i would like is that only the numeric keypad . will give a , as
>this is the numeric seperator symbol the keyboards ,. ( the ones below <>
>) should work as they do.
>
>someone an idea ???
>
>regards
>
>Michel Posseth
>
>
>
>
>
>[/color]
Is there some way of remapping that particular key?

T

[Fred Hedges]

Re: arrghh dot vs comma

I don't know if this will work; maybe overriding the keypress event? Will
it have side effects further on down the line?



Protected Overrides Sub OnKeyPress(ByVa l e As
System.Windows. Forms.KeyPressE ventArgs)

If e.KeyChar = "."c Then

Dim theNewEvent As New System.Windows. Forms.KeyPressE ventArgs(","c)

MyBase.OnKeyPre ss(theNewEvent)

Else

MyBase.OnKeyPre ss(e)

End If

End Sub





"tomb" <tomb@technetce nter.com> wrote in message
news:cBjcg.5545 0$iB2.9280@bign ews4.bellsouth. net...[color=blue]
> M. Posseth wrote:
>[color=green]
>>Hi ,,
>>i live in Europe in Europe the decimal seperator is , not a .
>>why is it so that if i press on my numeric keypad the . a . appears ??
>>
>>in my opinion it should be a , ( sounds odd but ... it should be so )
>>my problem :
>>i work currently in a companny where people do data entry with the numeric
>>keypad we are rewriting a cobol program ,,, in cobol you could just say
>>decimal seperator = dot or comma and it would work as expected . how can
>>we simulate the same thing in .net ??
>>windows settings are correct ( dutch settings ) , we work with a standard
>>qwerty international keyboards on all computers
>>so what i would like is that only the numeric keypad . will give a , as
>>this is the numeric seperator symbol the keyboards ,. ( the ones below
>><> ) should work as they do.
>>someone an idea ???
>>regards
>>
>>Michel Posseth
>>
>>
>>[/color]
> Is there some way of remapping that particular key?
>
> T[/color]

[M. Posseth]

Re: arrghh dot vs comma


Well ,,,

the calculator does it and excel does it

so there must be a way that we can do it to

i just found this

http://www.theproblemsolver.nl/dotnet_faq.htm

###############
Keyboard input of numeric values and commas as decimal separator
One of the questions I frequently get is how to get the same behavior as
Excel when entering numeric values. With the same behavior I mean that Excel
detects the current users setting for decimal separator and makes the point
on the numeric keyboard input the correct character. This is only done for
the numeric keypad, the point and comma on regular part of the keyboard
remain unchanged. Doing so is very easy but finding the right place is not
completely obvious as in most events the KeyEventArgs or Message parameters
cannot be changed or changing them has no effect. The proper place to do
this is the PreProcessMessa ge() function of a control. The code below does
just that, just subclass the a TextBox control and override the
PreProcessMessa ge() function and you are done.



Public Overrides Function PreProcessMessa ge( _
ByRef msg As System.Windows. Forms.Message) As Boolean
If msg.Msg = &H102 Then
If msg.WParam.Equa ls(New IntPtr(&H2E)) _
AndAlso msg.LParam.Equa ls(New IntPtr(&H530001 )) Then
' Point in the numeric keypad pressed
If
Thread.CurrentT hread.CurrentCu lture.NumberFor mat.NumberDecim alSeparator = ","
Then
' And the decimal separator is a ',' for the current settings
' Change the message to enter a comma instead of a poin
msg.WParam = New IntPtr(&H2C)
msg.LParam = am = New IntPtr(&H330001 )
End If
End If
End If

' Do the default actions
Return MyBase.PreProce ssMessage(msg)
End Function

############### ####

however this doesn`t work on a datagridview control

aaarghhh

:-(

why are things that should be easy sometimes so hard to acomplish :-|





"tomb" wrote:
[color=blue]
> M. Posseth wrote:
>[color=green]
> >Hi ,,
> >
> >i live in Europe in Europe the decimal seperator is , not a .
> >why is it so that if i press on my numeric keypad the . a . appears ??
> >
> >in my opinion it should be a , ( sounds odd but ... it should be so )
> >
> >my problem :
> >
> >i work currently in a companny where people do data entry with the numeric
> >keypad we are rewriting a cobol program ,,, in cobol you could just say
> >decimal seperator = dot or comma and it would work as expected . how can we
> >simulate the same thing in .net ??
> >
> >windows settings are correct ( dutch settings ) , we work with a standard
> >qwerty international keyboards on all computers
> >
> >so what i would like is that only the numeric keypad . will give a , as
> >this is the numeric seperator symbol the keyboards ,. ( the ones below <>
> >) should work as they do.
> >
> >someone an idea ???
> >
> >regards
> >
> >Michel Posseth
> >
> >
> >
> >
> >
> >[/color]
> Is there some way of remapping that particular key?
>
> T
>[/color]

[Hugh Janus]

Re: arrghh dot vs comma

This is by design and should not affect your program.

You can recreate this in other windows apps like calc.exe. If it type
"9.9", "9.9" appears on the window. Anway, you can customise it in the
regional settings applet from control panel.

[M. Posseth]

Re: arrghh dot vs comma

i have thought about this to however then you are not able to use a . when
you might need it


if i have a grid with 2 fileds for instance and i need to enter in the
second filed m. posseth i would get m, posseth

so it should only work on the numeric keypad`s .

regards

Michel Posseth


"Fred Hedges" wrote:
[color=blue]
> I don't know if this will work; maybe overriding the keypress event? Will
> it have side effects further on down the line?
>
>
>
> Protected Overrides Sub OnKeyPress(ByVa l e As
> System.Windows. Forms.KeyPressE ventArgs)
>
> If e.KeyChar = "."c Then
>
> Dim theNewEvent As New System.Windows. Forms.KeyPressE ventArgs(","c)
>
> MyBase.OnKeyPre ss(theNewEvent)
>
> Else
>
> MyBase.OnKeyPre ss(e)
>
> End If
>
> End Sub
>
>
>
>
>
> "tomb" <tomb@technetce nter.com> wrote in message
> news:cBjcg.5545 0$iB2.9280@bign ews4.bellsouth. net...[color=green]
> > M. Posseth wrote:
> >[color=darkred]
> >>Hi ,,
> >>i live in Europe in Europe the decimal seperator is , not a .
> >>why is it so that if i press on my numeric keypad the . a . appears ??
> >>
> >>in my opinion it should be a , ( sounds odd but ... it should be so )
> >>my problem :
> >>i work currently in a companny where people do data entry with the numeric
> >>keypad we are rewriting a cobol program ,,, in cobol you could just say
> >>decimal seperator = dot or comma and it would work as expected . how can
> >>we simulate the same thing in .net ??
> >>windows settings are correct ( dutch settings ) , we work with a standard
> >>qwerty international keyboards on all computers
> >>so what i would like is that only the numeric keypad . will give a , as
> >>this is the numeric seperator symbol the keyboards ,. ( the ones below
> >><> ) should work as they do.
> >>someone an idea ???
> >>regards
> >>
> >>Michel Posseth
> >>
> >>
> >>[/color]
> > Is there some way of remapping that particular key?
> >
> > T[/color]
>
>
>[/color]

[M. Posseth]

Re: arrghh dot vs comma

no not true

when i open calc or excel the keys are mapped

so i see 3,60 when i actually press 3.60 on my numeric keypad ( this is
how it should work )

however in my program or in notepad when i press the numeric seperator i
recive a . and i need it to be a , ( because of the regional settings )

as you see above in this thread there are workarounds that work on textbox
controls etc etc however it doesn`t seem to work on the datagridview control


anyone an idea

regards

Michel posseth





regards

Michel Posseth







"Hugh Janus" wrote:
[color=blue]
> This is by design and should not affect your program.
>
> You can recreate this in other windows apps like calc.exe. If it type
> "9.9", "9.9" appears on the window. Anway, you can customise it in the
> regional settings applet from control panel.
>
>[/color]

[Cor Ligthert [MVP]]

Re: arrghh dot vs comma

Michael,

Yes I know the problem in Holland, I once had a job where I was in tight
contact with IBM PC division.(which I assume had about 90% of the market
than).

I had the same problem as you and asked all the time at by instance Dutch
IBM Dealer meetings for a Dutch keyboard, meaning with that is the decimal
separator a comma instead of a dot and some additions to use the florin, and
some French characters signs under an alt key.

They were glad to present me at a certain moment the Dutch keyboard. I did
not understand how people could have made such a keyboard, but they told
that it was according the standard specification for a Dutch Typewriter from
somewhere before the World War II.

I am sorry; I myself have never used those and tried to avoid selling them.
But in that terrible thing is the decimal separator a comma. (I don't advice
you to use it, it is in my opinion ever worse than Azerty for us)

Cor

"M. Posseth" <MPosseth@discu ssions.microsof t.com> schreef in bericht
news:EA07776C-C1A5-4EF0-8403-4B6F26EB73BA@mi crosoft.com...[color=blue]
> Hi ,,
>
> i live in Europe in Europe the decimal seperator is , not a .
> why is it so that if i press on my numeric keypad the . a . appears ??
>
> in my opinion it should be a , ( sounds odd but ... it should be so )
>
> my problem :
>
> i work currently in a companny where people do data entry with the numeric
> keypad we are rewriting a cobol program ,,, in cobol you could just say
> decimal seperator = dot or comma and it would work as expected . how can
> we
> simulate the same thing in .net ??
>
> windows settings are correct ( dutch settings ) , we work with a standard
> qwerty international keyboards on all computers
>
> so what i would like is that only the numeric keypad . will give a , as
> this is the numeric seperator symbol the keyboards ,. ( the ones below
> <>
> ) should work as they do.
>
> someone an idea ???
>
> regards
>
> Michel Posseth
>
>
>
>[/color]

[Patrice]

Re: arrghh dot vs comma

On hwihc control have you tried Fred suggestion. IMO it shoulmd be done on a
control by control basis (for example you may want to use , instead of . for
a textbox that accept numeric values but would lioke still to use . if the
textbox is for entering text).

--
Patrice

"M. Posseth" <MPosseth@discu ssions.microsof t.com> a écrit dans le message de
news: 0CFD84AA-0EAD-49AF-95A8-BDA2742977CB@mi crosoft.com...[color=blue]
>i have thought about this to however then you are not able to use a . when
> you might need it
>
>
> if i have a grid with 2 fileds for instance and i need to enter in the
> second filed m. posseth i would get m, posseth
>
> so it should only work on the numeric keypad`s .
>
> regards
>
> Michel Posseth
>
>
> "Fred Hedges" wrote:
>[color=green]
>> I don't know if this will work; maybe overriding the keypress event?
>> Will
>> it have side effects further on down the line?
>>
>>
>>
>> Protected Overrides Sub OnKeyPress(ByVa l e As
>> System.Windows. Forms.KeyPressE ventArgs)
>>
>> If e.KeyChar = "."c Then
>>
>> Dim theNewEvent As New
>> System.Windows. Forms.KeyPressE ventArgs(","c)
>>
>> MyBase.OnKeyPre ss(theNewEvent)
>>
>> Else
>>
>> MyBase.OnKeyPre ss(e)
>>
>> End If
>>
>> End Sub
>>
>>
>>
>>
>>
>> "tomb" <tomb@technetce nter.com> wrote in message
>> news:cBjcg.5545 0$iB2.9280@bign ews4.bellsouth. net...[color=darkred]
>> > M. Posseth wrote:
>> >
>> >>Hi ,,
>> >>i live in Europe in Europe the decimal seperator is , not a .
>> >>why is it so that if i press on my numeric keypad the . a . appears ??
>> >>
>> >>in my opinion it should be a , ( sounds odd but ... it should be
>> >>so )
>> >>my problem :
>> >>i work currently in a companny where people do data entry with the
>> >>numeric
>> >>keypad we are rewriting a cobol program ,,, in cobol you could just
>> >>say
>> >>decimal seperator = dot or comma and it would work as expected . how
>> >>can
>> >>we simulate the same thing in .net ??
>> >>windows settings are correct ( dutch settings ) , we work with a
>> >>standard
>> >>qwerty international keyboards on all computers
>> >>so what i would like is that only the numeric keypad . will give a ,
>> >>as
>> >>this is the numeric seperator symbol the keyboards ,. ( the ones
>> >>below
>> >><> ) should work as they do.
>> >>someone an idea ???
>> >>regards
>> >>
>> >>Michel Posseth
>> >>
>> >>
>> >>
>> > Is there some way of remapping that particular key?
>> >
>> > T[/color]
>>
>>
>>[/color][/color]

[Michel Posseth [MCP]]

Re: arrghh dot vs comma


Exact and that is the reasson why i only want it on the numeric keypad dot
( this is how the Calculator and Excel do this )

regards

Michel Posseth


"Patrice" <scribe@chez.co m> schreef in bericht
news:eoxX1KbfGH A.1320@TK2MSFTN GP04.phx.gbl...[color=blue]
> On hwihc control have you tried Fred suggestion. IMO it shoulmd be done on
> a control by control basis (for example you may want to use , instead of .
> for a textbox that accept numeric values but would lioke still to use . if
> the textbox is for entering text).
>
> --
> Patrice
>
> "M. Posseth" <MPosseth@discu ssions.microsof t.com> a écrit dans le message
> de news: 0CFD84AA-0EAD-49AF-95A8-BDA2742977CB@mi crosoft.com...[color=green]
>>i have thought about this to however then you are not able to use a .
>>when
>> you might need it
>>
>>
>> if i have a grid with 2 fileds for instance and i need to enter in the
>> second filed m. posseth i would get m, posseth
>>
>> so it should only work on the numeric keypad`s .
>>
>> regards
>>
>> Michel Posseth
>>
>>
>> "Fred Hedges" wrote:
>>[color=darkred]
>>> I don't know if this will work; maybe overriding the keypress event?
>>> Will
>>> it have side effects further on down the line?
>>>
>>>
>>>
>>> Protected Overrides Sub OnKeyPress(ByVa l e As
>>> System.Windows. Forms.KeyPressE ventArgs)
>>>
>>> If e.KeyChar = "."c Then
>>>
>>> Dim theNewEvent As New
>>> System.Windows. Forms.KeyPressE ventArgs(","c)
>>>
>>> MyBase.OnKeyPre ss(theNewEvent)
>>>
>>> Else
>>>
>>> MyBase.OnKeyPre ss(e)
>>>
>>> End If
>>>
>>> End Sub
>>>
>>>
>>>
>>>
>>>
>>> "tomb" <tomb@technetce nter.com> wrote in message
>>> news:cBjcg.5545 0$iB2.9280@bign ews4.bellsouth. net...
>>> > M. Posseth wrote:
>>> >
>>> >>Hi ,,
>>> >>i live in Europe in Europe the decimal seperator is , not a .
>>> >>why is it so that if i press on my numeric keypad the . a . appears ??
>>> >>
>>> >>in my opinion it should be a , ( sounds odd but ... it should be
>>> >>so )
>>> >>my problem :
>>> >>i work currently in a companny where people do data entry with the
>>> >>numeric
>>> >>keypad we are rewriting a cobol program ,,, in cobol you could just
>>> >>say
>>> >>decimal seperator = dot or comma and it would work as expected . how
>>> >>can
>>> >>we simulate the same thing in .net ??
>>> >>windows settings are correct ( dutch settings ) , we work with a
>>> >>standard
>>> >>qwerty international keyboards on all computers
>>> >>so what i would like is that only the numeric keypad . will give a ,
>>> >>as
>>> >>this is the numeric seperator symbol the keyboards ,. ( the ones
>>> >>below
>>> >><> ) should work as they do.
>>> >>someone an idea ???
>>> >>regards
>>> >>
>>> >>Michel Posseth
>>> >>
>>> >>
>>> >>
>>> > Is there some way of remapping that particular key?
>>> >
>>> > T
>>>
>>>
>>>[/color][/color]
>
>[/color]

[Michel Posseth [MCP]]

Re: arrghh dot vs comma


Well Cor there must be a programatic solution ,,, as Microsoft uses this in
there products ( look at the calculator and Excel ) there the numeric
seperator key ( . on numeric keypad ) is swapped with a , if you go to
notepad the . still displays a . so i guess they are intercepring the
key in the program in some way

i have found some code that claimed it could do this the same way ( see up
in the thread ) however this doesn`t work in a datagridview control

regards

Michel




"Cor Ligthert [MVP]" <notmyfirstname @planet.nl> schreef in bericht
news:%23783bGbf GHA.5104@TK2MSF TNGP04.phx.gbl. ..[color=blue]
> Michael,
>
> Yes I know the problem in Holland, I once had a job where I was in tight
> contact with IBM PC division.(which I assume had about 90% of the market
> than).
>
> I had the same problem as you and asked all the time at by instance Dutch
> IBM Dealer meetings for a Dutch keyboard, meaning with that is the decimal
> separator a comma instead of a dot and some additions to use the florin,
> and some French characters signs under an alt key.
>
> They were glad to present me at a certain moment the Dutch keyboard. I did
> not understand how people could have made such a keyboard, but they told
> that it was according the standard specification for a Dutch Typewriter
> from somewhere before the World War II.
>
> I am sorry; I myself have never used those and tried to avoid selling
> them. But in that terrible thing is the decimal separator a comma. (I
> don't advice you to use it, it is in my opinion ever worse than Azerty for
> us)
>
> Cor
>
> "M. Posseth" <MPosseth@discu ssions.microsof t.com> schreef in bericht
> news:EA07776C-C1A5-4EF0-8403-4B6F26EB73BA@mi crosoft.com...[color=green]
>> Hi ,,
>>
>> i live in Europe in Europe the decimal seperator is , not a .
>> why is it so that if i press on my numeric keypad the . a . appears ??
>>
>> in my opinion it should be a , ( sounds odd but ... it should be so )
>>
>> my problem :
>>
>> i work currently in a companny where people do data entry with the
>> numeric
>> keypad we are rewriting a cobol program ,,, in cobol you could just say
>> decimal seperator = dot or comma and it would work as expected . how can
>> we
>> simulate the same thing in .net ??
>>
>> windows settings are correct ( dutch settings ) , we work with a
>> standard
>> qwerty international keyboards on all computers
>>
>> so what i would like is that only the numeric keypad . will give a , as
>> this is the numeric seperator symbol the keyboards ,. ( the ones
>> below <>
>> ) should work as they do.
>>
>> someone an idea ???
>>
>> regards
>>
>> Michel Posseth
>>
>>
>>
>>[/color]
>
>[/color]

[Herfried K. Wagner [MVP]]

Re: arrghh dot vs comma

"M. Posseth" <MPosseth@discu ssions.microsof t.com> schrieb:[color=blue]
> i live in Europe in Europe the decimal seperator is , not a .
> why is it so that if i press on my numeric keypad the . a . appears ??
>
> in my opinion it should be a , ( sounds odd but ... it should be so )[/color]

On my German ('de-AT') system pressing the "," key on the numpad a ","
appears. "," is the decimal separator in 'de-AT' and 'de-DE'.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

[Cor Ligthert [MVP]]

Re: arrghh dot vs comma

Herfried,

On the Dutch keyboard as well in Holland, but there is probably no sole that
is using that.

Cor

"Herfried K. Wagner [MVP]" <hirf-spam-me-here@gmx.at> schreef in bericht
news:eov2s$bfGH A.3888@TK2MSFTN GP04.phx.gbl...[color=blue]
> "M. Posseth" <MPosseth@discu ssions.microsof t.com> schrieb:[color=green]
>> i live in Europe in Europe the decimal seperator is , not a .
>> why is it so that if i press on my numeric keypad the . a . appears ??
>>
>> in my opinion it should be a , ( sounds odd but ... it should be so )[/color]
>
> On my German ('de-AT') system pressing the "," key on the numpad a ","
> appears. "," is the decimal separator in 'de-AT' and 'de-DE'.
>
> --
> M S Herfried K. Wagner
> M V P <URL:http://dotnet.mvps.org/>
> V B <URL:http://classicvb.org/petition/>[/color]

[Michel Posseth [MCP]]

Re: arrghh dot vs comma

yes that is probably the hole problem that eveyone in the Netherlands is
using a international QWERTY keyboard
however in my opinion it is strange that MS programs tackle this problem by
remapping the keys during runtime and that there seems to be no standard
method to reproduce this behavior for us .

if i could remap it permanently through a registry setting this would work
for me ( only for the dot on the numeric keypad should a comma appear )

so if someone knows how to do this i would be verry happy :-)

regards

Michel Posseth



"Cor Ligthert [MVP]" <notmyfirstname @planet.nl> schreef in bericht
news:uyuvN3cfGH A.3652@TK2MSFTN GP02.phx.gbl...[color=blue]
> Herfried,
>
> On the Dutch keyboard as well in Holland, but there is probably no sole
> that is using that.
>
> Cor
>
> "Herfried K. Wagner [MVP]" <hirf-spam-me-here@gmx.at> schreef in bericht
> news:eov2s$bfGH A.3888@TK2MSFTN GP04.phx.gbl...[color=green]
>> "M. Posseth" <MPosseth@discu ssions.microsof t.com> schrieb:[color=darkred]
>>> i live in Europe in Europe the decimal seperator is , not a .
>>> why is it so that if i press on my numeric keypad the . a . appears ??
>>>
>>> in my opinion it should be a , ( sounds odd but ... it should be
>>> so )[/color]
>>
>> On my German ('de-AT') system pressing the "," key on the numpad a ","
>> appears. "," is the decimal separator in 'de-AT' and 'de-DE'.
>>
>> --
>> M S Herfried K. Wagner
>> M V P <URL:http://dotnet.mvps.org/>
>> V B <URL:http://classicvb.org/petition/>[/color]
>
>[/color]

[Cor Ligthert [MVP]]

Re: arrghh dot vs comma

Michel,

I thought trying to to this problem for you today, I am not sure if I have
time for that because I go out in some minutes.

It would be based on the fact that you can cast a textbox in a datagrid and
use its events.

I would use the keyup event and watch if the value is a dot and replace that
than by a comma and a comma by a dot. (You have than to play with the
selected position and things like that, but I assume that you know that,
there are plenty of samples in this newsgroup about the numeric textbox and
in fact do you have to extend that).

I had the idea that I did something before.

Cor