Bug 146725 - Calc is taking much time to process paste command of unformatted text
Summary: Calc is taking much time to process paste command of unformatted text
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks: Paste-Special-Unformatted
  Show dependency treegraph
 
Reported: 2022-01-12 23:30 UTC by elias estatistics
Modified: 2024-02-12 21:09 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Paste Unformatted Text Hang (Column E) (1.21 MB, application/vnd.oasis.opendocument.spreadsheet)
2022-01-16 17:54 UTC, Tex2002ans
Details

Note You need to log in before you can comment on or make changes to this bug.
Description elias estatistics 2022-01-12 23:30:11 UTC
Steps to reproduce: 

1) Select data in "E" column and copy them
2) At E5 cell, right click, paste special, Unformatted text
3) It is taking ages.... 

(original calc is 5 times of the rows of that).

Solution:
1) Paste Special --> Paste Special (Values only) 
.... in less than second jod done!  


File (available for 15 days from now) 
--- https://filepost.io/d/wodLB8nFcA


Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: d5ade739771ddf06cc7ee6d4af15672bfcf09ed6
CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: kf5 (cairo+xcb)
Locale: el-GR (el_GR.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-09-01_02:56:07
Calc: threaded
Comment 1 Tex2002ans 2022-01-16 17:51:32 UTC
I can reproduce in:

Version: 7.2.5.2 (x64) / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

After Step 3, LibreOffice uses a full core + has a loading bar with "Load Document" which barely moves.

(I waited for more than 2 minutes, and LibreOffice was just stuck with a white "frozen" screen.)

Note: I'm attaching your document to Bugzilla.
Comment 2 Tex2002ans 2022-01-16 17:54:38 UTC
Created attachment 177585 [details]
Paste Unformatted Text Hang (Column E)
Comment 3 Tex2002ans 2024-02-12 21:09:58 UTC
Much better than it was in 7.2.5.

It finally pasted after:

- ~2 minutes

but still VERY slow compared to what you'd expect.

Using:

Version: 24.2.0.3 (X86_64) / LibreOffice Community
Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1
CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded