Description: Pasting selected text from a word processor (Writer or Word) results in the text being pasted as an image rather than text. I cannot envisage a user scenario where this is desirable behaviour. If a users selects text, the assumption is that text will be pasted. At best, the insertion of text as image should be an Insert Special but not default behaviour. Steps to Reproduce: 1.Select text in Word or Writer 2.Ctrl + v in Calc Actual Results: Instead of text, an image is paste Expected Results: Text is pasted Reproducible: Always User Profile Reset: No Additional Info: This is unlikely to be a user profile issue, I tried this on 2 systems (both Windows 10) and the result is the same. User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:56.0) Gecko/20100101 Firefox/56.0
Sure it's an image and not an *object*? Try double click to see the difference.
Ok amend wording from "image" to "object" (well spotted) but it's still bonkers default behaviour.
can Reproduce Description: I have tried to reproduce and in my case it seems a bit different. when i copied a text from writer to Calc it works fine but when copy from Calc and paste it in writer it pasted in image format. Steps to reproduce: Case 1: 1. select a text 2. copy and paste it in writer *in this case it pastes in image format case 2: 1. select a text in Calc 2. shade it 3. paste it in writer *in this case paste text Windows 10 Version: 5.4.2.2 (x64) Build ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4 CPU threads: 8; OS: Windows 6.19; UI render: default; Locale: en-US (en_US); Calc: group
Comment 3 describes something different than comment 0. When copy-pasting (not paste-special) an entire cell or multiple cells from Calc to Writer, the target is an embedded spreadsheet object that you can double click and edit. This is not a bug. If you want only text then paste special and choose Unformatted Text, or to preserve the cell structure and paste as Writer table choose Formatted Text [RTF]. I can not reproduce the original description's Writer to Calc behavior, I get text instead of object (Linux, 5.4.2 and 5.4.3), unless I paste special selecting LibreOffice 5.4 Text Document.
I believe I was involved in a similar bug where the behaviour on Linux and Windows was markedly different. But I can't put my finger on the bug.
Michael: does this happen with any, freshly created Writer document?
Writer? Did you mean Calc? Anyway, I opened a new Writer document and a new Calc document, wrote some words, copied them, pasted them into the new Calc document with ctrl v and I get an object, not text in Calc.
(In reply to Michael Bauer from comment #7) > Writer? Did you mean Calc? Anyway, I opened a new Writer document and a new > Calc document, wrote some words, copied them, pasted them into the new Calc > document with ctrl v and I get an object, not text in Calc. So is the result identical, if you right-click, Paste special and select LibreOffice Text document?
Paste Special works as expected. This was never about whether Paste Special works or not, this is about the default paste action when using Ctrl C and Ctrl V, pasting text into Calc that ends up being not text. I cannot see the use case for the default paste action inserting text as an object being bigger than that for pasting text as text. Same for same, both logically and in (my) practical experience dominates.
(In reply to Michael Bauer from comment #9) > Paste Special works as expected. This was never about whether Paste Special > works or not, this is about the default paste action when using Ctrl C and > Ctrl V, pasting text into Calc that ends up being not text. > > I cannot see the use case for the default paste action inserting text as an > object being bigger than that for pasting text as text. Same for same, both > logically and in (my) practical experience dominates. I meant: do you get the same unwanted result, when you Paste Special - Text document? Ie. is your erroneous default action the same as pasting as Text document?
No, as I said Paste Special works i.e. if I tell it to Paste Special Text Only, I get text.
(In reply to Michael Bauer from comment #11) > No, as I said Paste Special works i.e. if I tell it to Paste Special Text > Only, I get text. No, I did not mean unformatted text, I meant LibreOffice Text document. That is the only case where I get an object inserted. Please try it.
So when I open Paste Special, there are 6 options: * [RTF] [Richtext] HTML Unformatted DDE link * > text inserted as object RTF > text inserted as text Richtext > Error, says cannot paste from clipboard HTML > text inserted as text but smaller pt size, not sure how I'd see if it's HTML Unformatted > text inserted as text DDE link > inserts link to the Writer document
No repro, Version: 6.0.0.0.alpha0+; win7, but I can repro with 5.4.2. Pasted object is OLE object - editable with double click. In version 6 is default back to paste text. Please check with dev version. http://dev-builds.libreoffice.org/daily/master/
There seems to be a pattern of this coming and going, I am sure I've come across the problem before and then it went away for a while and now it's back. Doing a big of digging, someone reported an OO Calc to LO Calc problem just like that in 2010 (Bug 31077) and Bug 109011 from earlier this year (watch the .gif, it has the same problem except he's pasting from Excel).
(In reply to Michael Bauer from comment #15) > There seems to be a pattern of this coming and going, I am sure I've come > across the problem before and then it went away for a while and now it's > back. Doing a big of digging, someone reported an OO Calc to LO Calc problem > just like that in 2010 (Bug 31077) and Bug 109011 from earlier this year > (watch the .gif, it has the same problem except he's pasting from Excel). Ok, let us know what result you get with https://dev-builds.libreoffice.org/daily/master/Win-x86_64@42/current/
I will give it a go but if this is a problem that comes and goes, should we not try and identify why it comes and goes? Just because 6.0.0.0 does not seem to have it does not sound like a guarantee it's not going to come back in 6.0.0.1?
Sorry this too a while. I downloaded that dev version you linked: 1 When pasting from Word, the outcomes is the same, it still results in an OLE object 2 When pasting from Writer, text only is inserted
(In reply to Michael Bauer from comment #18) > Sorry this too a while. I downloaded that dev version you linked: > > 1 When pasting from Word, the outcomes is the same, it still results in an > OLE object > 2 When pasting from Writer, text only is inserted Ok, so the original problem is corrected so we can close this.
Errrmm... no? Read the original description? This was always about Word AND Writer: >1.Select text in Word or Writer So just because by a fluke Writer seems to be working, this does not resolve the original bug in full.
Ok, let's clarify the summary. I confirmed the default behaviour with MSO 2013 and LibO 6.1 master build.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Default CTRL-V actions of a text string: Word > Writer : pastes as text Word > Calc : pastes as OLE object Writer & Calc > Writer & Calc : pastes as text Writer & Calc > Writer & Calc : pastes as text So yes, still Word > Calc is the only facepalm default action.
The last line was meant to read: Writer & Calc > Word & Excel: pastes as text
While the bug seemed to have gone away in the previous version, it's back in 7.2.0.4, paste from Word inserts an OLE object. Ridiculous... and we expect people to take FOSS seriously...
I was able to reproduce it. It did not have an issue when pasting text from Writer to Calc, but it does when pasting text from Word to Calc. Version: 7.5.3.2 (X86_64) / LibreOffice Community Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3 CPU threads: 6; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-ES (en_US); UI: en-US Calc: threaded
For Windows users not having MSO, this can be also replicated by using Wordpad (included in any Windows version). No repro in AOO 4.1.14. No repro in LO 3.3, nor in LO 4.2.0.4. Repro in all LO versions from 4.4 up to LO Dev 24.2 built on 2023-06-21; this includes LO 7.0.x too. It would seem that the default format/action/result for normal PASTE [CTRL]+[V] has changed in LO 4.4. Considering that other possible formats/actions/results are available with paste special, and that the normal paste action works as expected from Writer, perhaps the current behavior is not as inadequate after all.
>perhaps the current behavior is not as inadequate after all. Except that's a whole lot of extra clicking. There's simply no use case for the default behaviour being insertion of an OLE object. At the very least, the behavious should be consistent...