Apache OpenOffice (AOO) Bugzilla – Issue 103327
Option for default copy/paste to work with unformatted text
Last modified: 2013-02-07 22:39:53 UTC
When using the copy / paste features of Calc, the application works with formatting as well as data. The application needs an option to make the default copy and paste operations be plain text. Currently, the user must use the paste button's dropdown menu to paste plain text. This is especially important when working with documents that have sections separated by borders: Calc will erase the borders of cells if "unformatted text" is not careful selected at each paste.
Issue 17563 is fixed for 3.2, but I don't know whether the fix there also solves the problem here.
Thank you Rainer. It seems that Issue 17563 asks for a keyboard shortcut, which would serve _me_ well. However, my users are mousemaids who need to simply middle-click to paste plain text. Thanks.
A function for setting (UI) the default clipboard cannot be implemented because not all clipboard formats are always available (what should happen when the default format has been set to "Unformatted text" but an image has been copied?).
Closed
Closed? What closed? > A function for setting (UI) the default clipboard cannot be > implemented because not all clipboard formats are always available > (what should happen when the default format has been set to > "Unformatted text" but an image has been copied?). It is understood that this would only affect text.
It could be then an entry "Paste Unformatted Text" under "Tools - Options - OpenOffice.org - View - Middle mouse button". Reassigned
Yes, that would be fine. Thank you.
@dotancohen: The workaround from Issue 17563 (Additional comments from watersrw Mon Jan 31) Also works in Spreadsheet, I use it regularly with an extra button in the toolbar.
Thank you Rainer, but I would rather avoid such workarounds. I myself am not an OOo guru by any means, and I am just helping an organization (actually, two organizations) use OOo in place of their usual office suite which is not available on their new OS. I would like to introduce as few complications as possible, and macros are certainly out of bounds! If this issue could be resolved for OOo 3.2 it would save these guys quite some time and frustration. It would also make their decision to move to FOSS look good, as they knew that a lot of functionality would be missing in the beginning but as issues are filed things would get better. I'd like to see that actually happen. Thanks!
3.2.0 now has the Paste Special icon on the toolbar by default, at least on the Mac, which gives you the four alternatives, and that's good. Haven't tried middle mouse button yet. But most of my cutting and pasting is done with Cmd-C and Cmd-V, and as far as I know there is no Cmd-? for Paste Special, so making unformatted text default would definitely be a plus.