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.
Add the possibility to assign key board short cut by adding in EDIT, FUNCTION "Paste unformatted text"
Operating System: Windows XP
Version: 126.96.36.199 release
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.
This looks like it might be a duplicate of bug 50746 (Calc) and bug 51525 (Impress).
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).
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.
The shortcut was added and so this case works for me in 188.8.131.52.