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 ?
pasting to excel changes . to , points to comma
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 !!!!!!!!!
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 !!!!!!!!!
This is related to Windows region settings. Try to add a ' prefix to define a text formatted cell:
Or, as suggested above, use the clipboard method (Type: Command):
Code: Select all
'AAAAAAAAA, BBBBBBBBBB, CCCCCCCCCCC. CCCCCCCCCCC.
Code: Select all
clipboard:="'AAAAAAAAA, BBBBBBBBBB, CCCCCCCCCCC. CCCCCCCCCCC."
send ^v