Apache OpenOffice (AOO) Bugzilla – Issue 76492
Make Paste intelligent. If clipboard contains table, paste as HTML
Last modified: 2016-12-30 04:11:30 UTC
When pasting the following document in Calc, it does not behave the same if I copy the table from IE (does not behave as expected) or Firefox (behaves nicely). http://www.openoffice.org/nonav/issues/showattachment.cgi/44519/test.html See screenshots. This may be related somehow to issue 76412.
Created attachment 44530 [details] pasted from Firefox
Created attachment 44531 [details] pasted from IE
Hi, not a defect. Firefox places HTML code into the clipboard, IE also RTF, RTF is the best choice for normal Office content like formatted text from Writer to Calc, so it's the default paste format. If you don't like the result, use Paste Special HTML Format and you get the same result as if you use firefox to copy from. Frank
closed invalid
Well, I suppose that every user when using IE to paste in Calc would expect that the table would be pasted in different cells. Simple users will never know about the special paste formats. When they use Excel, things work as one would expect. They will thus conclude than OOo is buggy. Any idea how this could be changed to behave nicely when pasting in Calc? Enhance the RTF filter in Calc? Is there already an issue about it?
Confirming and changing to enh. Pierre-Andre, I suggest changing summary to better reflect your idea (like "Make Paste intelligent - in Calc, if clipboard contains table, paste as HTML"). P.S. Paste special allows one to select most sutable format.
As enhancement assigned to requirements.