Bug 157659 - Cut / Copy / Paste / Delete of Rows in Calc 7.5+ is slow
Summary: Cut / Copy / Paste / Delete of Rows in Calc 7.5+ is slow
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.0.1 rc
Hardware: x86-64 (AMD64) Windows (All)
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks: Cell-Management
  Show dependency treegraph
 
Reported: 2023-10-08 19:01 UTC by q326507
Modified: 2023-11-10 21:35 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
OpenDocument Spreadsheet for testing (9.54 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-10-10 23:15 UTC, q326507
Details

Note You need to log in before you can comment on or make changes to this bug.
Description q326507 2023-10-08 19:01:25 UTC
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
Comment 1 Xisco Faulí 2023-10-10 10:19:01 UTC
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.)
Comment 2 q326507 2023-10-10 23:15:38 UTC
Created attachment 190129 [details]
OpenDocument Spreadsheet for testing
Comment 3 q326507 2023-10-10 23:17:34 UTC
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.
Comment 4 Stéphane Guillou (stragu) 2023-10-22 19:58:47 UTC
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!
Comment 5 q326507 2023-10-23 03:38:14 UTC
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).
Comment 6 Buovjaga 2023-10-31 17:24:31 UTC
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