decimal symbol copy/paste

[Bertrand_ENAC]

Hello,

I would like to copy some cells in an Excel sheet using <Ctrl C> and paste them to a table control using <Ctrl V>. The problem is that with my regional settings the decimal symbol in Excel is a comma and the table control needs a dot.

I tried to change the Editor Preferences to Use localized decimal symbol but the behaviour remains the same.

Is there I way to solve this issue?

Thanks

Bertrand

[LuisG]

Hello Bertrand,

The Editor Preferences setting only determines what happens in the User Interface Editor. Are you trying to paste your cells into a table in the Editor (in operate mode)? Or are you trying to paste them into a table in a running program?

If it's the latter, then it's not the Editor Preferences that you need to change. You need to change the following system attribute in your program:

SetSystemAttribute (ATTR_USE_LOCALIZED_DECIMAL_SYMBOL, 1);

Luis

Message Edited by LuisG on 02-27-2009 04:35 PM

[Bertrand_ENAC]

Thank you Luis, now it's working.

It was pasting in a running program I wanted to do.

Perhaps do you have an advise how I can turn the hit on the dot key on the numeric keypad so it is recognized as a comma.

In Excel it is working like that. It is in fact not very convenient to enter numbers using the comma from the alphabetic key pad.

Thanks

Bertrand

[Guillaume Dargaud]

> Perhaps do you have an advise how I can turn the hit on the dot key on the
> numeric keypad&nbsp;so it is recognized as a comma.

There is a small powerful program for all kind of keyboard related
shortcuts: http://www.autohotkey.com/
I use it for accents on US keyboards.
--
Guillaume Dargaud
http://www.gdargaud.net/

[LuisG]

Hi Bertrand,

Also, in case you're not aware of this, you can always remap your keyboard so that it mimics keyboards used in other countries. Some keyboard mappings (German, for example) use a comma instead of the dot in the numeric keypad.

If you want to try it, do the following steps (in English Windows XP):

1. Run the Control Panel

2. Select Regional and Language Options

3. Click the Languages tab

4. Click the Details button

5. Click the Add button

6. Select the Input Language that you wish and click OK (you might have to do some trial and error here -- so far, all the international keyboard mappings that I've found on the internet leave out the numeric keypad)

You now should have a small language indicator in the Language bar (on the right-hand side of the taskbar). To toggle languages you need only click <Alt-Shift> which is pretty easy and quick, once you get used to it.

Luis