Page 2 of 2

Re: pasting to excel changes . to , points to comma

Posted: May 22nd, ’20, 06:19
by Mr.Aky
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 [email protected] 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 [email protected]

Is it a (language) problem of my excel ?

Re: pasting to excel changes . to , points to comma

Posted: Dec 11th, ’20, 10:48
by Antopath
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 !!!!!!!!!

Re: pasting to excel changes . to , points to comma

Posted: Dec 12th, ’20, 09:06
by Marko
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