Am experiencing some erratic and very frustrating behaviour pasting table contents copied from a proprietary 3rd party application (running in a VMWare virtual machine, but don’t see how that could be a factor - functions work normally into Excel). 1) I copy the table with multiple columns by highlighting then CTRL C 2) I try to paste it into Calc running natively (ie not in a virtual machine). Sometimes it works as expected, other times the entire contents of a table row is pasted into the first cell of a column. Other times it works as expected correctly inserting it into correct columns in Calc, but only after 3 or 4 attempts via CTRL V. Sometimes CRTL V does not work, but paste special SHIFT+CTRL V does work! But it really seems to be very random, although I have noticed the failure rate of ordinary CRTL V tends to increase dramatically when the row count of a table to be pasted is relatively small, maybe 8-15 rows. This was certainly working reliably last year and probably spring 2025 too, but something appears to have broken since
Please paste here the information on Menu/Help/About LibreOffice (There is an icon to copy) Is there any clipboard manager installed?
Many thanks for your reply! No, there is no dedicated clipboard manager installed (just the standard windows functionality) Version info: Version: 25.2.5.2 (X86_64) / LibreOffice Community Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: CL threaded
Please test disabling the clipboard history in the system.
Clipboard history in the systems settings was already off! Thanks again for you attention to this matter
Please test in safe mode, Menu/Help/Restart in Safe Mode
no change/improvement in safe mode unfortunately.
We are sorry, but as it is not possible to access that application under these conditions, I have no option to test it.
I have just reproduced exactly the same behaviour copy/pasting from the Open Source DBeaver database workbench application, copying data from a table with 7 columns/fields and seven rows. 1) Highlight data, then CTRL C to Copy, and CTRL V into Calc 2) First CTRL V worked as expected, correctly inserting into cells, so did the second time, 3rd time entire row contents pasted into the first column cell, with items space delimited. On my first attempt
Are you sure when pasting the second/third time, the focus is in the same place?
Not sure quite what you mean by if "the focus is in the same place?" No, I pasted into new locations on the Calc sheet, a few rows immediately below the prior paste. But I am not CTRL C/copying anything new before, so it is the same item in the clipboard buffer that just comes out randomly. Which is the same basic faulty behaviour that I initially raised. It should be consistent, right?
Hi again, this is the first time I have ever filed a bug report on this platform, and I am a little confused/concerned that the status is still showing as unconfirmed, now that I have provided a route to demonstrating this random behaviour. Is the reason for that you do not consider it a bug, as prior comments seemed to suggest If so this software is not useable for me. You have to have confidence in what commands produce, otherwise too much time is simply wasted, with frustration building. Thanks for any information on where this is going!
This is an open source project, and although we appreciate your cooperation, as volunteers, we are unable to confirm the issue at this time. Please note the special configuration you report. Copying from an unknown application from a VM
right but i have confirmed it from DBeaver which is a known, open source database workbench. See https://dbeaver.io/ You can also get it via Chocolatey Seems to me clear there is a fundamental issue copy/pasting into Calc from apps that produce plain text data tables. Understand this is open source, volunteer maintained software, and that's why I have tried to be as helpful as possible, and generally want to support this philosophically. But this kind of behaviour has to be stable for me to use it. Randomness is simply a dealbreaker, and I suspect similarly so for other reasonably "power users".
This is following tdf#165744 Not marked as duplicate because the old one is resolved fixed. Tested with the sample database of dbeaver. The possible issue is that sometimes the separator change to Detected (none) instead of Detected (tab) Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 8bf0692331c335fc285794de8858eb555b19e1d1 CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Hi Bodgan, can you take a look
Created attachment 202878 [details] Text file to reproduce the issue. The file was produce copying from DBeaver a table (with copy without special options, pasted in Notepad++ and saved as txt. Opening the file in Notepad, select all, copy. Pasting in a new spreadsheet, works fine at first glance, but e.g. pasting in a new sheet, the detected separator change to none.
Sometimes Detected (none) appears after change to Separated by.
Thanks to m_a_riosv for persevering with this. Would just like to reiterate for anybody trying to replicate, for some strange reason this behaviour especially - but not exclusively - manifests when a relatively small number of rows is copied/pasted (7-10 in my experience). Many thanks!