On Friday, August 11, 2017 at 3:42:33 AM UTC-7, wrote:
paste special option is showing only Unicode text or text. ...

The full variety of "paste special" choices is generally available when copying from Excel.

Copying from other kinds of source results in fewer choices, as you observe.