I was just experiencing the same problem. I'm using KDE with the Klipper clipboard tool.
Trying to copy from a web page then paste special into LO spreadsheet.
The paste special option was grayed out.
Clearing the Klipper history fixed the problem.
Cheers,
--Algot