Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Another method is to record a simple macro that contains the paste special code with the desired options and to assign that to a toolbar button. This can even be done with the macro recorder alone

  • enable macro recording in Tools | Options → LibreOffice → General
  • copy a cell, so that paste special will be available
  • Record a macro using Tools | Macros → Record macro
  • <>ctrl>+<shift>+v, select desired options, click OK
  • choose a name for the macro and save.

Then go to Tools | Macros → Organize → LibreOffice Basic, select "assign" button. With that you can assign the macro to a menu entry, a toolbar button or a keyboard shortcut.