Using Ctrl+V to paste unformatted text by default in OpenOffice.org's Calc

Question

Is there a way to change the Ctrl+V command in OpenOffice.org Calc to paste unformatted text?

There is Ctrl + Shift + V, which puts up a dialog. But that is too much work. I just want to change the default Ctrl+V behaviour.

Answer 1

Autohotkey!

^+v::
bak = %clipboard%
clipboard = %bak%
Send ^v
return

That would replace Control-Shift-V with an "unformatted" paste, globally.

If you wanted it OOo Calc only, you'd do something like:

#IfWinActive, ahk_class [something]
^v::
bak = %clipboard%
clipboard = %bak%
Send ^v
return
#IfWinActive

Where [something] is the window's Class name, which you could easily find out with AHK's bundled Window Spy. (This one would actually replace Control-V (^ means control, + means shift), but doing that systemwide is a bad idea)

Answer 2

Why complicate things? A simpler way to paste Unformated Text with Ccontrol V is simply to record a macro (paste icon in top icon menu) where you manually paste unformated text. Next go to Tools, Adjust and select category macro, your macto, and the control-v option.

Save

Everytime you now use ctrl-v your text is pasted unformated.