pasting to excel changes . to , points to comma
I'm using excel in italian
When copy a text a put the clipboard value into User_1
When I paste i use
Clipboard:=User_1
Sendinput, %Clipboard%
If I copy an email address for example test.test@hotmail.it
If i paste in notepad it is pasted as test.test@hotmail.it
but if I paste to excel it is pasted as test,test@hotmail,it (with commas)
Do you know how to solve this issue ?
When copy a text a put the clipboard value into User_1
When I paste i use
Clipboard:=User_1
Sendinput, %Clipboard%
If I copy an email address for example test.test@hotmail.it
If i paste in notepad it is pasted as test.test@hotmail.it
but if I paste to excel it is pasted as test,test@hotmail,it (with commas)
Do you know how to solve this issue ?
Have you saved the email address to User variable?
There is no need to use a Clipboard:
Type: Send
There is no need to use a Clipboard:
Type: Send
Code: Select all
%A_User_1%
I have changed the variable to %User_1%
but when I paste name.surname@gmail.com in excel (italian) it becomes
name,surname@gmail,com
in notepad it is pasted as name.surname@gmail.com (points are preserved)
Massimo
but when I paste name.surname@gmail.com in excel (italian) it becomes
name,surname@gmail,com
in notepad it is pasted as name.surname@gmail.com (points are preserved)
Massimo
Are you using a text expander? Can you post an image of your setting (abbreviation, substitute)?
No, I don't use them
https://www.loom.com/share/ce3048ea5812 ... 0c686090fe
As you can see correctly nome.cognome is sent to libreoffice calc but in the cell I see nome,cognome
Do you have any idea why this happens ?
Or I can I solve this problem ?
Massimo
https://www.loom.com/share/ce3048ea5812 ... 0c686090fe
As you can see correctly nome.cognome is sent to libreoffice calc but in the cell I see nome,cognome
Do you have any idea why this happens ?
Or I can I solve this problem ?
Massimo
Can you post your Shortcut setting and the User variable setting?
https://app.box.com/s/f0uv7fr2mw2trrrl9vc70n2j4y6uf17p
https://app.box.com/s/pfkjcm0fnyufl05ityhikhu3f0e5blao
Do you mean these settings ?
https://app.box.com/s/pfkjcm0fnyufl05ityhikhu3f0e5blao
Do you mean these settings ?
I mean where is the Alt+1 shortcut you use defined? And where is User_7 variable defined?
Copy shotcut
ClipBoard:=""
Send ^c
ClipWait
Clipboard=%Clipboard%
Sleep, 200
User_1 := ClipBoard
Paste shortcut
Sendinput, %User_1%
A copy of nome.cognome@test.it in excel produces nome,cognome@test,it
If instead of Sendinput, %User_1% I use Send ^v it pastes correctly nome.cognome@test.it .
Why this happens ?
And why the problem is only in excel ?
Massimo
ClipBoard:=""
Send ^c
ClipWait
Clipboard=%Clipboard%
Sleep, 200
User_1 := ClipBoard
Paste shortcut
Sendinput, %User_1%
A copy of nome.cognome@test.it in excel produces nome,cognome@test,it
If instead of Sendinput, %User_1% I use Send ^v it pastes correctly nome.cognome@test.it .
Why this happens ?
And why the problem is only in excel ?
Massimo
Why are you complicating? If all you want is pasting clipboard content without formatting then you only need this paste shortcut:
Code: Select all
clipboard=%clipboard%
sleep 100
Send, ^v