Bug 61771 - EDITING: enable keyboard shortcut key to paste unformatted text
Summary: EDITING: enable keyboard shortcut key to paste unformatted text
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: UI (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: Other Windows (All)
: low enhancement
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2013-03-04 02:14 UTC by bugquestcontri
Modified: 2018-08-09 21:17 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description bugquestcontri 2013-03-04 02:14:51 UTC
Problem description: 
Pasting unformatted text is the way in LibO to keep the destination format. This is a better way than MSO's handling of "keep destination format" However, one has to go via ctrl+shift+v and then select "unformatted text". This is a loss of productivity.

Enhance solution:
Add the possibility to assign key board short cut by adding in EDIT, FUNCTION "Paste unformatted text"
Operating System: Windows XP
Version: release
Comment 1 Rainer Bielefeld Retired 2013-03-04 07:04:25 UTC
Currently we have this shortcut for Writer (<alt+control+shift+v>) by default. 
In other applications "Paste plain Text" or similar is not offered in the Customize dialog so that.

Simple workaround, you can record a macro.

An Easyhack would be to create a small Extension adding this function (similar to recorded macro). 

I checked 3.3.3, function also missing in Customize dialog. Seems we never had that.
Comment 2 dg1727 2014-02-05 20:51:25 UTC
This looks like it might be a duplicate of bug 50746 (Calc) and bug 51525 (Impress).
Comment 3 Andrzej Hunt 2014-02-14 18:57:38 UTC
Commit 84b4b7b931b194fc4d1980d2fa9c7fd6e0c9134c which fixed
#51525 should also fix this bug for Impress/Draw. There is no "paste unformatted" per se for calc yet (there is a "paste only text" -- but that literally pastes only text, and doesn't paste numbers/dates/etc. so hardly counts as equivalent), so not entirely fixed. I'm not sure we shouldn't just mark this as a duplicate of #50746, seeing as adding the functionality means that the shortcut will automatically work (or at least *should* automatically work).
Comment 4 pb 2015-10-14 22:02:06 UTC
Is there any sense on how often users want to paste FORMATTED text into Calc from the clipboard?  My sense is that the answer is essentially never.

This problem has been there for many years, and also in openoffice.

It would make sense for Calc, that pasting unformatted text from the clipboard should be the default, and if not, then a preference item should exist for the user to make it the default, without the need to navigate the customization labyrinth.

Meanwhile, here and in numerous other places around the web it has been suggested to simply record a macro to do this.  In that case:

1.  Do macros actually work in the portable version?

2.  The macro recording process is not trivial -- it would help if someone created a macro and told people exactly how to load it.

Also, in the past, when I attempted to use a macro to do this, there were unexpected results when a range of cells needed to be pasted.  In the default UI, this appears to require more steps than just selecting paste special > unformatted text.
Comment 5 Markus Grob 2018-08-09 21:17:33 UTC
The shortcut was added and so this case works for me in