pasting to excel changes . to , points to comma

Discussion, questions and support.
Mr.Aky
Posts: 17
Joined: May 21st, ’19, 06:49

Post by Mr.Aky » May 22nd, ’20, 06:19

Thank you for your support,
I'im investing a bug (or something I do not know) of a more complex macro.

Do you know why

When copy nome.cognome@test.it and put the clipboard value into User_1
When I paste if I use

Clipboard:=User_1
Sendinput, %Clipboard%

becomes nome,cognome@test,it (with commas)
while if I use

Clipboard:=User_1
Send ^v
it pastes correctly nome.cognome@test.it

Is it a (language) problem of my excel ?
Antopath
Posts: 7
Joined: Dec 8th, ’20, 10:09

Post by Antopath » Dec 11th, ’20, 10:48

Hi all !!
Has anybody ever noticed the fault translation/interpretation of commas and periods with Word or Excel ?

The FastKeys phrase:
AAAAAAAAA, BBBBBBBBBB, CCCCCCCCCCC. CCCCCCCCCCC.

is correctly expanded in Word, whereas in Excel becomes:
AAAAAAAAA, BBBBBBBBBB, CCCCCCCCCCC, CCCCCCCCCCC,

Excel translates periods always as commas ...... Do you think that these characters need to be highlighted somehow in FastKeys to be correctly interpreted?

Thanks !!!!!!!!!
User avatar
Marko
Posts: 1719
Joined: Mar 2nd, ’13, 21:02

Post by Marko » Dec 12th, ’20, 09:06

This is related to Windows region settings. Try to add a ' prefix to define a text formatted cell:

Code: Select all

'AAAAAAAAA, BBBBBBBBBB, CCCCCCCCCCC. CCCCCCCCCCC. 
Or, as suggested above, use the clipboard method (Type: Command):

Code: Select all

clipboard:="'AAAAAAAAA, BBBBBBBBBB, CCCCCCCCCCC. CCCCCCCCCCC."
send ^v
Post Reply