Post by account_disabled on Nov 23, 2017 6:28:49 GMT
Hi all,
I've prepared a little workflow for a boring job to do.
we have to prepare a list of names and surnames from a bunch of different sources(sheets,docs,text files,mails, etc.)
the workflow is simple but useful, it has a list keywords entries, and each of them calls a different little php script that takes the text on the clipboard and converts it passing it to a 'Copy to Clipboard' element that pastes it again. I am also attaching Hotkey triggers to the most used functions.
so I can copy and convert on the fly I.E. 'John Doe', 'Doe John', 'Doe, John' and other combinations and have it pasted as 'JohnTABDoe', with the TAB I have it pasted on a excel sheet on two columns with name separated by surname.
Now I have a problem when the text is copied from a sheet calc in Libre Office or Open Office:
if the text inside the cell is SELECTED and then copied, then the paste is handled as usual and it's OK.
but if I select simply the cell and copy and then call the script, then all the process seems to be ignored and it's the original cell to be pasted...
the text seems to be copied and treated fine, because on other apps is pasted without problems, but inside Office,
is like in that case the 'Copy to Clipboard' with automatic paste on front most app is ignored
is this normal behaviour, and there's a workaround?
Hope the question was clear
Please help....
I didn't find the right solution from the Internet.
References
www.alfredforum.com/topic/8495-spreadsheet-copypaste-problem/
Corporate Whiteboard Examples
I've prepared a little workflow for a boring job to do.
we have to prepare a list of names and surnames from a bunch of different sources(sheets,docs,text files,mails, etc.)
the workflow is simple but useful, it has a list keywords entries, and each of them calls a different little php script that takes the text on the clipboard and converts it passing it to a 'Copy to Clipboard' element that pastes it again. I am also attaching Hotkey triggers to the most used functions.
so I can copy and convert on the fly I.E. 'John Doe', 'Doe John', 'Doe, John' and other combinations and have it pasted as 'JohnTABDoe', with the TAB I have it pasted on a excel sheet on two columns with name separated by surname.
Now I have a problem when the text is copied from a sheet calc in Libre Office or Open Office:
if the text inside the cell is SELECTED and then copied, then the paste is handled as usual and it's OK.
but if I select simply the cell and copy and then call the script, then all the process seems to be ignored and it's the original cell to be pasted...
the text seems to be copied and treated fine, because on other apps is pasted without problems, but inside Office,
is like in that case the 'Copy to Clipboard' with automatic paste on front most app is ignored
is this normal behaviour, and there's a workaround?
Hope the question was clear
Please help....
I didn't find the right solution from the Internet.
References
www.alfredforum.com/topic/8495-spreadsheet-copypaste-problem/
Corporate Whiteboard Examples