Description: When copying a field (or a selection of multiple fields) into clipboard the system is blocked for about 10 seconds (mouse-waiting symbol) before it's possible to continue working. This happens always when copying the first time after opening the calc file. Subsequent copy-actions are quick. It happens at a large table (more than 20000 lines). Steps to Reproduce: 1. Open calc file with large table 2. Click into any (not empty) field 3. Type Ctrl-C for copy into clipboard Actual Results: Mouse pointer changes into waiting symbol for several seconds and system is blocked Expected Results: Having the field copied into clipboard without delay Reproducible: Always User Profile Reset: Yes Additional Info: [Information automatically included from LibreOffice] Locale: de Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no Version: 24.2.5.2 (X86_64) / LibreOffice Community Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: threaded
Please attach a sample file(s), reduce the size as much as possible without private information.
Created attachment 195563 [details] Example file The file is rather complex with four tabs with calculations and diagrams. I've realized that when removing the calculation/diagram tabs the file size is reduced and the delay when copying into the clipboard the first time disappears. This might be a quite special use case. Nevertheless, I'd expect that copying fields into the clipboard wouldn't trigger any re-calculations, so I wouldn't expect the delay. Hopefully helpful information. Thanks!
Reproducible, Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 4be345abd678babcbb989db1e7a16021ad1da562 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded First version that fails on the ones I have installed. Version: 24.2.3.2 (X86_64) / LibreOffice Community Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded Latest version that works on the ones I have installed. Version: 24.2.1.1 (X86_64) / LibreOffice Community Build ID: 359ef544e625d2ffbfced462ab37bd593ca85fa7 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded There is some delay, at the first copy on the range: Log.A21298:A21301 But always a delay in: Tag.A2:A4 Seems it is in relation with charts, on the last range deleting the chart in the sheet avoids the issue.
tried bisecting in 24.2 but couldnt find anything In 24.8 seem to point to commit: 709866a3b8e073fab4937dcf91dcd33ff1d2bc13 author Mike Kaganski Sun Mar 03 02:04:24 2024 commit message: tdf#99969: make sure to copy the chart source ranges to clipboard.
Did not find anything in 24.8 24a08fcf600f0590972cd9943423dc22c0a2016c is the first bad commit commit 24a08fcf600f0590972cd9943423dc22c0a2016c (origin/master, master) Author: libreoffice <libreoffice@libreoffices-MacBook-Air.local> Date: Tue Oct 29 03:35:47 2024 +0100 source f6c9d1012d20541f6373b51ff3c25d8fd7bc8c69 source f6c9d1012d20541f6373b51ff3c25d8fd7bc8c69 LibreOffice.app/Contents/Frameworks/libvcllo.dylib | Bin 15743184 -> 15743184 bytes LibreOffice.app/Contents/Resources/setuprc | 2 +- LibreOffice.app/Contents/Resources/versionrc | 2 +- 3 files changed, 2 insertions(+), 2 deletions(-)
This seems to have begun at the below commit in bibisect repository/OS linux-64-24.8. Adding Cc: to Mike Kaganski ; Could you possibly take a look at this one? Thanks 2cc979e273617d37e10ab7657ddfa562bdcfb268 is the first bad commit commit 2cc979e273617d37e10ab7657ddfa562bdcfb268 Author: Jenkins Build User <tdf@maggie.tdf> Date: Sun Mar 3 01:48:44 2024 +0100 source 709866a3b8e073fab4937dcf91dcd33ff1d2bc13 164294: tdf#99969: make sure to copy the chart source ranges to clipboard | https://gerrit.libreoffice.org/c/core/+/164294 There is a two second delay on my PC.
(In reply to m_a_riosv from comment #3) > But always a delay in: > Tag.A2:A4 Thanks for the mention! People writing things like "any (not empty) field" don't realize how their "I'm sure it will be reproducible always, so I won't take a smallest effort to add "e.g. X1, which I tested right now" to help others" makes others' lives more difficult. This is not a bug. The change made exactly that. The range Tag.A2:A4 contains the chart's anchor; so the anchor is copied to the clipboard. Copying the anchor, you have to copy its data range. It may be complex, but it has to be done, to avoid bad copy. I remove myself and the regression bits. It may be a perf issue, and someone may have skills to improve it.
Thanks @Mike, the explanation it's enough for me, I return the bug to unconfirmed. Also with the navigator I can see four instances of 'Char 1', they look the same, deleting three duplicates, the copy improves a lot.