Description: Copying and pasting discontinuous cells produces different results in Windows 10 and Windows 11. If you select non-contiguous cells in Calc (Ctrl+click on the cells) and paste them into another portion of the spreadsheet or into a new spreadsheet, the following occurs: In Windows 10: Filled cells are pasted contiguously (no empty cells among them) In Windows 11: Empty cells are pasted along with filled cells (but you didn't select them in the source area) This behavior is new in Windows 11 and is not consistent with expectations. The correct behavior is the one in Windows 10, where only the cells selected with Ctrl+click are pasted. Steps to Reproduce: 1. In a Calc spreadsheet write something in cells A1, A3, A5 2. Select A1, A3 and A5 and copy into the clipboard note that you have selected and copied discontinous celss 3. Paste somewhere in the same sheet or in a new sheet 4. The selection pasted includes empty cells, that corresponds to A2 and A4, but only if you are on Windows 11 Actual Results: The pasted selection includes empty cells (no matter if the corresponding cells in the source area were empty or not) Expected Results: empty cells are pasted Reproducible: Always User Profile Reset: Yes Additional Info: Only the cells selected with CTRL-CLICK in the source area should have been pasted, without any blank cells between them.
Hello cianoz, Thank you for reporting the bug. I can confirm that the bug is present in master and alpha0 version when using Windows 10. When I followed your instructions and then selected E1 to paste the cells E1,E2,E3 were filled with the data from A1,A3,A5 respectively. Version: 25.8.3.2 (X86_64) Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e CPU threads: 8; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 620(Build:0) CPU threads: 8; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded
You can work around this by searching for clipboard settings in Windows system settings and turning off clipboard history. I also reproduced this issue using CopyQ on Ubuntu. However, due to the fix commit of tdf#169554, this issue no longer occurs in the nightly version of 11-28. This bug can be considered fixed
This issue can be reproduced using CopyQ on Windows, but it should be treated as a separate bug.