Description: Cutting and pasting tabular data from another device's user interface which incorporates "traffic light" graphics. Normally, the procedure is to paste special as unformatted text. Any other paste functionality simply carries the unwanted "traffic lights". These graphics remain pasted into the sheet when the user realises the error and endeavours to undo the paste either with the undo button or XTRL+Z. Workaround requires that each graphic element be selected and deleted. If the user is aware then the "Drawing Functionality" interface can be activated and all the elements selected and deleted in one go - otherwise it's quite tedious to select each item individually for deletion. Steps to Reproduce: Sample Enclosed. Source data is derived from an electronic door control system. The first cluster of four entries is simply CTRL+V which doesn't offer a text import dialogue box and forces text wrap into the cell (I adjusted it afterwards for presentation purposes) NOTE the traffic lights. The second cluster is the desired effect with CTRL+SHFT+V and selecting "unformatted text" NOTE the absence traffic lights The Third Cluster is the intentional replication of the first cluster by means of another copy and paste special but erroneously selecting "Stripped HTML" NOTE the traffic lights The fourth cluster is again the erroneously copied third cluster AFTER UNDO. NOTE only traffic lights Actual Results: Unwanted graphic elements Expected Results: complete UNDO of the paste action NOTE double UNDO does not remove the graphic elements - it simply reverses the prior editing. Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Version: 7.2.5.2 (x64) / LibreOffice Community Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5 CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: sv-SE (en_GB); UI: en-GB Calc: threaded
Created attachment 178968 [details] Sample Sample .ods It can only graphically demonstrate the scenario. Obviously, saving the file removed any activity chain as I don't have "History" enabled
It might be helpful to upload the clipboard data that you get from the door control system. You could install https://hluk.github.io/CopyQ/ clipboard manager, run it, copy the data and then in CopyQ say File - Export. Others can then test with the data you attach.
Created attachment 184318 [details] Replacement .ods containing the data from attached clipboard file
Created attachment 184319 [details] Clipboard data to complement the .ods
(In reply to Buovjaga from comment #2) > It might be helpful to upload the clipboard data that you get from the door > control system. You could install https://hluk.github.io/CopyQ/ clipboard > manager, run it, copy the data and then in CopyQ say File - Export. Others > can then test with the data you attach. New files are attached. I selected non-personalised entries so there's only one "traffic light" colour and very little other data
(In reply to Colin from comment #5) > (In reply to Buovjaga from comment #2) > New files are attached. I selected non-personalised entries so there's only > one "traffic light" colour and very little other data. Correction: I also included just the first element of a personalised entry but the selection allowed me to exclude the personality. Therefore, two traffic lights.
(In reply to Colin from comment #4) > Created attachment 184319 [details] > Clipboard data to complement the .ods After I import this to CopyQ and select Edit - Copy selected items, it pastes into Calc without any graphics :(
(In reply to Buovjaga from comment #7) > (In reply to Colin from comment #4) > > Created attachment 184319 [details] > > Clipboard data to complement the .ods > > After I import this to CopyQ and select Edit - Copy selected items, it > pastes into Calc without any graphics :( I just downloaded it myself and it produces the graphics - and also when it's pasted into Excel. I did notice that CopyQ presents two tabs when the file's imported imported and it's the newer tab that's valid - is that the same for you? Are you using Windows? Are you using a later version of LO?
(In reply to Colin from comment #8) > (In reply to Buovjaga from comment #7) > > (In reply to Colin from comment #4) > > > Created attachment 184319 [details] > > > Clipboard data to complement the .ods > > > > After I import this to CopyQ and select Edit - Copy selected items, it > > pastes into Calc without any graphics :( > I just double clicked the desired entry in CopyQ - could that have an impact?
Version: 7.4.2.3 (x86) / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: threaded Present in this as well
Sorry, I forgot to mention I used Linux. My Windows VM is broken at the moment, I will probably install a fresh one next week. Arch Linux 64-bit Version: 7.4.2.3 / LibreOffice Community Build ID: 40(Build:3) CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US 7.4.2-1 Calc: threaded
(In reply to Buovjaga from comment #11) > Sorry, I forgot to mention I used Linux. My Windows VM is broken at the > moment, I will probably install a fresh one next week. > Is that implying a different bug in the linux version? - it doesn't copy the graphics even if they're in the clipboard🤔
Also not reproducible on Windows ... possibly because the HTML in the clipboard contains references to some unreachable host: <img src="http://slx-0044f6/images/icon_cat2.gif" align="ABSMIDDLE"> and pasting it creates some delay (likely trying to resolve the "slx-0044f6"), then pasting without the images.
(In reply to Mike Kaganski from comment #13) > Also not reproducible on Windows ... possibly because the HTML in the > clipboard contains references to some unreachable host: > > <img src="http://slx-0044f6/images/icon_cat2.gif" align="ABSMIDDLE"> > > and pasting it creates some delay (likely trying to resolve the > "slx-0044f6"), then pasting without the images. Should I conduct some more experiments with something captured from the internet to see if "undoing" that paste has a similar effect. If it's just related to my electronic door locks then I don't think the rest of the community are too concerned🤔 and it becomes a "Works for MK"😎
Created attachment 184367 [details] Clipboard content with accessible http url Thanks, Mike. I don't know if it was necessary, but I edited the clipboard file with a hex editor and replaced the first url with a random one I had in my history. I needed a http url as opposed to https in order to test with old versions. I see the same behaviour in 6.3, 3.5 on Linux. Arch Linux 64-bit, X11 Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: b844605b101bd752c8a0c07117b5d3faf2b2aebb CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Jumbo Built on 22 December 2022
Found a dupe *** This bug has been marked as a duplicate of bug 39217 ***