I use Toad (Quest Software) quite a bit, as well as SQL Developer and Crystal Reports.
In the past, I would copy text from Toad, which had color and is a mono-spaced font, to Word or Outlook, and the coloring and spacing would persist.
Since sometime in early April, my options for pasting to Microsoft applications are 'Keep Text Only (T)'. In Word, my paste settings are not messed up - the option is 'Keep Source Formatting'.
This works fine. I have paste options and can cut and paste html text from
- Outlook to Word, Excel
- Chrome to Word, Excel, Outlook
- SQL Server code to Word, Outlook, (Excel has more options, but they are still just text)
- Visual Studio code to Word, Outlook, (Excel has more options, but they are still just text)
- SQL Developer to Outlook (has font, not color)
I can only paste text from
- Toad to Word, Excel, Outlook
- SQL Developer to Word, Excel
- Crystal Reports to Word, Outlook, (Excel has more options, but they are still just text)
I just upgraded Toad from 13.0 to 13.1.1. I have Office 365 ProPlus version 1808, and I have an update for that scheduled for tonight. Since there are unrelated applications (Crystal, Toad) having the same issue pasting to Microsoft products, it seems like an Office or Windows issue.
This link Paste Special Option missing doesn't help, because it is too old. And while I have Skype, it's a newer version than this link is talking about, too. In case it is related, my Skype version is Skype for Business for Office 365 MSO (16.0.10730.20264) 32-bit.
My help desk has reinstalled office. Today we were looking at rebuilding my profile, but the problem existed for the profile for the help desk person too, so we did not.
Other than the Office upgrade, what else might be the problem? Where else do we look?
We have found one work-around. Paste the text to Notepad++ and change the language to SQL. Then under Plugins, choose NPPExport and Copy all formats to clipboard. Then, from there, I can paste to Word or other Office apps. That is several steps instead of just a simple copy/paste like I was doing. Like I'd like to do again.