Paste unformatted text default option [closed]
Is there any way to set Paste Special (Unformatted text) as the default option when using Ctrl Shift V to paste in Calc, Writer etc? I have read that it is possible to create a macro and then assign a keyboard shortcut to it. I'm just wondering if there is a configuration option to toggle pasting formatted text to unformatted text as the default so that a paste special prompt isn't displayed every time I paste some formatted text.
Alternatively, is there a way to set the import options to a default so that there isn't a prompt for import options after pressing Ctrl V to paste?
None of these options work or are clearly explained. The actual solution is to select the cell you want to paste into, and then select the forumla bar at the top and CTRL + V to paste into the formula bar and NOT the cell.