Description: Beginning with LibreOffice 7.5 and continuing through the latest "fresh" release (7.6.2), I've been experiencing a delay lasting a couple of seconds when cutting, copying, pasting and deleting rows in Calc. By "delay" I mean that a blue loading wheel appears and the program becomes unresponsive for a couple of seconds. This did not occur in LibreOffice 7.4.7 or earlier. A few things I've noticed: 1. This only affects rows. Cutting, copying, pasting or deleting columns, individual cells or groups of cells is not affected. 2. It doesn't matter if one row is selected or multiple rows, the delay is always the same. 3. The problem only manifests after I've pasted a row (or multiple rows) of data in Calc. In other words, when I first open a document I can cut, copy and delete rows indefinitely without any issue. It's only after I paste a row (or group of rows) that every subsequent cut/copy/paste/delete operation involving rows experiences a delay. 4. After testing some earlier versions of LibreOffice, I noticed that there was a very brief delay in 7.4.7 as compared to 7.3.7, which seemed quicker. I hadn't noticed this before because it's so short, but it's possible the roots of this problem can be traced back to before 7.5. 5. All of this is on Windows 10 and affects both the 32-bit and 64-bit versions of LibreOffice. To reproduce the issue: 1. Create a new OpenDocument Spreadsheet or open an existing spreadsheet in LibreOffice Calc 7.5 or later. 2. Select any row by clicking on the row number on the left side of the window. It doesn't matter if any of the cells contain data. 3. Select Cut or Copy from the context menu or use one of the keyboard shortcuts (Ctrl+X or Ctrl-C). This operation will perform normally. 4. Select any other row by clicking on the row number on the left side of the window. Select Paste from the context menu or use the keyboard shortcut Ctrl+V. A loading wheel should appear and the program will become unresponsive for approximately 2 seconds. 5. At this point any subsequent cut/copy/paste/delete operations performed on any individual row or group of rows will experience the same delay until the document is closed and re-opened. Steps to Reproduce: 1. Create a new OpenDocument Spreadsheet or open an existing spreadsheet in LibreOffice Calc 7.5 or later. 2. Select any row by clicking on the row number on the left side of the window. It doesn't matter if any of the cells contain data. 3. Select Cut or Copy from the context menu or use one of the keyboard shortcuts (Ctrl+X or Ctrl-C). This operation will perform normally. 4. Select any other row by clicking on the row number on the left side of the window. Select Paste from the context menu or use the keyboard shortcut Ctrl+V. A loading wheel should appear and the program will become unresponsive for approximately 2 seconds. 5. At this point any subsequent cut/copy/paste/delete operations performed on any individual row or group of rows will experience the same delay until the document is closed and re-opened. Actual Results: Any cut, copy, paste or delete operation performed on any individual row or group of rows causes a loading wheel to appear and the program to become unresponsive for approximately 2 seconds. Expected Results: Cut, copy, paste and delete operations performed on rows should complete quickly (ie. the same speed as the same operations performed on columns, individual cells or groups of cells). Reproducible: Always User Profile Reset: Yes Additional Info: N/A
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 190129 [details] OpenDocument Spreadsheet for testing
Thanks for responding. Since this bug affects all spreadsheets, you can just create a new document. I've attached a simple test document created on my computer, should it help.
Not reproduced on Linux: Version: 7.6.2.1 (X86_64) / LibreOffice Community Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded But possibly Windows-specific. Do you use some extra clipboard tool at all? If you do, could you please test without it activated? And please also share the full version information from Help > About LibreOffice (there's a button to copy). Thank you!
I don't use any clipboard tools. Here's my current version information: Version: 7.5.7.1 (X86_64) / LibreOffice Community Build ID: 47eb0cf7efbacdee9b19ae25d6752381ede23126 CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded Although I'm currently running version 7.5.7.1 (X86_64), I've experienced this problem in all 7.5.x and 7.6.x versions I've tried, including both 32-bit and 64-bit versions. The last working version appears to be 7.4.7.2 (which is the last version before 7.5). However, even with that version I can detect a very brief delay as compared to version 7.3.7.2 (the last version before 7.4).
I reproduce on Windows, but this seems to be due to the number of columns going from 1024 to 16 thousand. Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 676e0527d2f31556eccae314fbb12ce204f02ec7 CPU threads: 2; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-US (en_FI); UI: en-US Calc: threaded