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?
My favorite shortcut key for 'Paste unformatted text' is 'Ctrl+U', assigned to that macro:
sub paste_unformatted
rem ----------------------------------------------------------------------
rem define variables
dim document as object
dim dispatcher as object
rem ----------------------------------------------------------------------
rem get access to the document
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
rem ----------------------------------------------------------------------
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = "SelectedFormat"
args1(0).Value = 1
dispatcher.executeDispatch(document, ".uno:ClipboardFormatItems", "", 0, args1())
end sub
You may create this macro as follows:
(1) Record macro
Ctrl+Shift+V > U > Enter
Stop recording
(2) [New window: LibreOffice Basic Macros]
Type 'Macro name' (e.g.): 'paste_unformatted' > Save
(3) Tools > Customize > Keyboard > Functions > Category > LibreOffice Macros > user > Standard > Module1
Function > 'paste_unformatted'
Shortcut keys > Ctrl+U > Modify > OK
Actually, it is quite easy. Just follow these steps (on the PC version 3.5, at least):
That's it! :)
HTH, Robert~
"In Writer text documents, you can press Ctrl+Alt+Shift+V to paste the contents of the clipboard as unformatted text. " http://help.libreoffice.org/Common/Pasting_Contents_in_Special_Formats
Doesn't exactly deal with defaults, but perhaps useful in the meanwhile!
i did same paste special, but it doesn't work. the formula is still on active. ideally after paste special formula should not reflect.
Unfortunately, these options are not so configurable and you'll need a macro to do what you wanting.
I don't know how to make a makro, but it should do the follwing (German UI...): Press: ALT + B + H Press: ENTER Press: ENTER
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-03-09 03:28:20 +0200
Seen: 5,299 times
Last updated: Nov 02 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
