[Solved] How to paste unformatted by default?
[Solved] How to paste unformatted by default?
I've always hated the preservation of formatting when copying text from a web page into a word processing document. At home, I use the Opera web browser, which thankfully does not support this "feature" and just gives me the plain text when I copy with Ctrl+C, but here at work I'm stuck using Firefox, which does.
Is there any way to tell OpenOffice to always paste "unformatted" plain text when using Ctrl+V? It's really a hassle to have to go select Edit > Paste Special... > Unformatted Text > Okay every time I want to paste something from a web page (or any other source, really). I never want formatting to be preserved, even copying and pasting within a single document.
Alternatively, if any of you are Firefox users, is there anything I can do on the Firefox side of things to get only the text copied to the clipboard?
Is there any way to tell OpenOffice to always paste "unformatted" plain text when using Ctrl+V? It's really a hassle to have to go select Edit > Paste Special... > Unformatted Text > Okay every time I want to paste something from a web page (or any other source, really). I never want formatting to be preserved, even copying and pasting within a single document.
Alternatively, if any of you are Firefox users, is there anything I can do on the Firefox side of things to get only the text copied to the clipboard?
Last edited by Canary on Mon Mar 30, 2009 9:55 pm, edited 1 time in total.
Re: How to paste unformatted by default?
Hi and welcome to the forums.
You could record a macro and then assign it to a toolbar or menu or keystroke. Go to Tools > Macros > Record Macro, then press the sequence of keystrokes you want. At the end of your sequence click on Stop Recording. In the new window that pops up, give the file a name (PastePlain for example) and save it under soffice > Standard > Module1.
In Tools > Macros > Organize Macros > OpenOffice.org Basic expand the Macro From tree to show My Macros->Standard->Module and highlight PastePlain in the macro list. Click the Assign button and you can assign it to a menu or to a toolbar icon. Tools Customise > Keyboard tab should let you put it on a keystroke.
If this has answered your question please go to your first post and use the Edit button, and add [Solved] to the start of the title. You can use the green tick icon at the same time if you like.
You could record a macro and then assign it to a toolbar or menu or keystroke. Go to Tools > Macros > Record Macro, then press the sequence of keystrokes you want. At the end of your sequence click on Stop Recording. In the new window that pops up, give the file a name (PastePlain for example) and save it under soffice > Standard > Module1.
In Tools > Macros > Organize Macros > OpenOffice.org Basic expand the Macro From tree to show My Macros->Standard->Module and highlight PastePlain in the macro list. Click the Assign button and you can assign it to a menu or to a toolbar icon. Tools Customise > Keyboard tab should let you put it on a keystroke.
If this has answered your question please go to your first post and use the Edit button, and add [Solved] to the start of the title. You can use the green tick icon at the same time if you like.
Ubuntu 14.10 Utopic Unicorn, LibreOffice Version: 4.3.3.2
Gurkha Welfare Trust
Gurkha Welfare Trust
Re: How to paste unformatted by default?
Also see this thread: http://user.services.openoffice.org/en/ ... =6&t=11286.
The current target for changing the issue is OOo 3.2, but I can no longer tell what the plan is. The simple idea of providing a shortcut for "Paste as unformatted" seems to have morphed into something else, but I can't tell what.
I guess we'll just have to wait and see what happens.
The current target for changing the issue is OOo 3.2, but I can no longer tell what the plan is. The simple idea of providing a shortcut for "Paste as unformatted" seems to have morphed into something else, but I can't tell what.
I guess we'll just have to wait and see what happens.
AOO4/LO5 • Linux • Fedora 23
- franklekens
- Posts: 133
- Joined: Thu Oct 30, 2008 11:05 am
- Location: Amsterdam
Re: How to paste unformatted by default?
For the time being, as alternatives for Menu Edit Paste Special, you can of course assign a shortcut key to "Paste special". I'm not sure if you can assign CTRL+V to it, it might be protected. But CTRL+SHIFT+V or (CTRL+)ALT+V might make life easier at least a little.
And the clipboard button on the toolbar has a dropdown menu as well.
As for Firefox: https://addons.mozilla.org/en-US/firefo ... xt&cat=all
Esp. https://addons.mozilla.org/en-US/firefox/addon/134
And maybe https://addons.mozilla.org/en-US/firefox/addon/134 while you're at it.
And the clipboard button on the toolbar has a dropdown menu as well.
As for Firefox: https://addons.mozilla.org/en-US/firefo ... xt&cat=all
Esp. https://addons.mozilla.org/en-US/firefox/addon/134
And maybe https://addons.mozilla.org/en-US/firefox/addon/134 while you're at it.
--
Frank Lekens
OOo 4.4.0 on Ms Windows 8.1
(compatibility: MS Office 2013)
Frank Lekens
OOo 4.4.0 on Ms Windows 8.1
(compatibility: MS Office 2013)
Re: How to paste unformatted by default?
Good links--thanks!
Yes, you can assign Paste Special to Ctrl+V if you want, but it doesn't seem like a big win to have to navigate the "paste special" dialog for every paste.
Umm, Ctrl+Shift+V is the default shortcut for Edit > Paste Special.But CTRL+SHIFT+V or (CTRL+)ALT+V might make life easier at least a little.
Yes, you can assign Paste Special to Ctrl+V if you want, but it doesn't seem like a big win to have to navigate the "paste special" dialog for every paste.
AOO4/LO5 • Linux • Fedora 23
Re: How to paste unformatted by default?
This seems to do the trick. Thanks!TheGurkha wrote:... You could record a macro and then assign it to a toolbar or menu or keystroke. ...
-
- Posts: 1
- Joined: Tue May 12, 2009 5:57 pm
Re: [Solved] How to paste unformatted by default?
I'd strongly recommend this solution to make your life easier. It creates macro and assigns shortcut to it, so you can copy paste unformatted by clicking Ctrl+Alt+V for example. Watch this video tutorial to complete the task:
http://www.myhowtoos.com/en/excel-howto ... in-ms-word
http://www.myhowtoos.com/en/excel-howto ... in-ms-word
OOo 2.3.X on Ms Windows XP
Re: [Solved] How to paste unformatted by default?
But all of that relates to Microsoft Word. This is the Openoffice.org forum.davide1982 wrote:I'd strongly recommend this solution to make your life easier. It creates macro and assigns shortcut to it, so you can copy paste unformatted by clicking Ctrl+Alt+V for example. Watch this video tutorial to complete the task:
http://www.myhowtoos.com/en/excel-howto ... in-ms-word
Ubuntu 14.10 Utopic Unicorn, LibreOffice Version: 4.3.3.2
Gurkha Welfare Trust
Gurkha Welfare Trust
Re: [Solved] How to paste unformatted by default?
Just a follow-up, since I mentioned above that OOo 3.2 would include some changes, and 3.2 betas are now coming out.
It looks like there will be a new shortcut key: Ctrl+Alt+Shift+V (no, really, four keys at once) that will paste the clipboard as unformatted text. Here's what the online help says:
I guess it's better than having to use a menu of some sort, but having to press four keys at once doesn't seem like much of a "shortcut".
But... also new in 3.2, you can now assign functions to Alt+key combinations, and it works just fine to assign "Edit/Paste Unformatted Text" to Alt+V. That's much better, but you have to do the customization step; it won't be available everywhere.
OOo 3.2 is due out 14-Dec-2009: http://wiki.services.openoffice.org/wiki/OOoRelease32
It looks like there will be a new shortcut key: Ctrl+Alt+Shift+V (no, really, four keys at once) that will paste the clipboard as unformatted text. Here's what the online help says:
Ctrl+Shift+V is still "Paste Special," as before.Ctrl+Alt+Shift+V
Pastes unformatted text from the clipboard. The text is pasted using the format that exists at the insertion point.
I guess it's better than having to use a menu of some sort, but having to press four keys at once doesn't seem like much of a "shortcut".
But... also new in 3.2, you can now assign functions to Alt+key combinations, and it works just fine to assign "Edit/Paste Unformatted Text" to Alt+V. That's much better, but you have to do the customization step; it won't be available everywhere.
Edit: PS: |
AOO4/LO5 • Linux • Fedora 23
Re: [Solved] How to paste unformatted by default?
I just installed the 3.2 beta. Could you tell me how to set the Paste unformatted to an Alt+key combination? I still see only Paste special in the Customize/Edit options...
MOD: sorry for not being specific. Calc does not have Paste unformatted, but Writer does... Seems I shall use Writer for spreadsheets for now
MOD: sorry for not being specific. Calc does not have Paste unformatted, but Writer does... Seems I shall use Writer for spreadsheets for now
Last edited by gabore on Tue Nov 24, 2009 1:40 pm, edited 1 time in total.
OpenOffice 3.2 beta on Win7
Re: [Solved] How to paste unformatted by default?
Hi,
I've changed the shortcut to Ctrl+U - but there it is →
OOo-dev 3.2.0 (OOO320_m5) [ http://download.openoffice.org/next/index.html ]
I've changed the shortcut to Ctrl+U - but there it is →
OOo-dev 3.2.0 (OOO320_m5) [ http://download.openoffice.org/next/index.html ]
LibreOffice 4.0.4 · WinXP
Re: [Solved] How to paste unformatted by default?
(1) That's the Writer forumgabore wrote:[...]
MOD: sorry for not being specific. Calc does not have Paste unformatted, but Writer does... Seems I shall use Writer for spreadsheets for now
(2) For Calc:
See the post by TheGurka, this thread: 28 Mar 2009 22:02
My recorded macro Paste unformatted text (works fine in Calc):TheGurkha wrote:[...] You could record a macro and then assign it to a toolbar or menu or keystroke. [...]
Code: Select all
sub 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
LibreOffice 4.0.4 · WinXP
Re: [Solved] How to paste unformatted by default?
About the macro: It works as a charm, thanks.
About the forum: Well, this is what happens when you appear here in 'write only' mode I guess...
About the forum: Well, this is what happens when you appear here in 'write only' mode I guess...
OpenOffice 3.2 beta on Win7
Re: [Solved] How to paste unformatted by default?
3 years later, there's still no option to just have it paste unformatted by default.
I don't get this. Are there ever anyone who wants to use formatted paste? The only reason anyone ever uses it, is because it's default. Particularly in spreadsheets, it is only a nuisance, and not of any help. Even in Writer, all formatted pasting does, is screw up your document, unless it's something you pasted from open office of course. That's the only time that's you'd want to keep the formatting.
The path to unformatted pasting is simply too long.
I don't get this. Are there ever anyone who wants to use formatted paste? The only reason anyone ever uses it, is because it's default. Particularly in spreadsheets, it is only a nuisance, and not of any help. Even in Writer, all formatted pasting does, is screw up your document, unless it's something you pasted from open office of course. That's the only time that's you'd want to keep the formatting.
The path to unformatted pasting is simply too long.
OpenOffice 3.1.1 on Windows XP
Re: [Solved] How to paste unformatted by default?
Too much trouble.oggologgo wrote:3 years later, there's still no option to just have it paste unformatted by default.
Meoggologgo wrote:Are there ever anyone who wants to use formatted paste?
Ctrl+Shift+V U Enteroggologgo wrote:The path to unformatted pasting is simply too long.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: [Solved] How to paste unformatted by default?
There is a shortcut for it in the default configuration: Ctrl+Alt+Shift+V
You can configure your own--simpler?--shortcut for it as well.
You can configure your own--simpler?--shortcut for it as well.
AOO4/LO5 • Linux • Fedora 23
Re: [Solved] How to paste unformatted by default?
I'm always astonished about the behave of the Ctrl-V function and the styles formatting.
Maybe I've used the pasting of styles 1% of the times in Writer, but for sure 0% of the times in Calc.
So, the 99% of times when using Writer, and 100% of times when using Calc, EVERY SINGLE pasting sequence is:
- right click
- paste special
- unformatted text
- "OK"
I've tried the four-keys sequence, but for the sake of my hand tendons, I must say... this is NOT an option.
Fiddling with the Windows clipboard is another Pandora's vase that I would like to keep closed...
So now I'm going to try writing macros, assigning hotkeys and so on, but let me simply say that this is SO FRUSTRATING !!!
Maybe I've used the pasting of styles 1% of the times in Writer, but for sure 0% of the times in Calc.
So, the 99% of times when using Writer, and 100% of times when using Calc, EVERY SINGLE pasting sequence is:
- right click
- paste special
- unformatted text
- "OK"
I've tried the four-keys sequence, but for the sake of my hand tendons, I must say... this is NOT an option.
Fiddling with the Windows clipboard is another Pandora's vase that I would like to keep closed...
So now I'm going to try writing macros, assigning hotkeys and so on, but let me simply say that this is SO FRUSTRATING !!!
OpenOffice 3.4.1 on Windows XP Pro
- Hagar Delest
- Moderator
- Posts: 32658
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: [Solved] How to paste unformatted by default?
Why macros? There are shortcuts already for paste as unformatted text. Just change the default shortcut (that's what I've done on my system).
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10