Bug 142996 - Copy large cell range in Calc is very slow (20s in Calc vs 1s in Excel)
Summary: Copy large cell range in Calc is very slow (20s in Calc vs 1s in Excel)
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.0.3 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks:
 
Reported: 2021-06-23 03:49 UTC by Kevin Suo
Modified: 2022-02-20 08:31 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Suo 2021-06-23 03:49:11 UTC
It is very slow for the copy operation in Calc. Copying a large cell range from an ODS file takes 20s in Calc, while the same data if exported to xlsx and open in MS Excel it only takes 1s.

Steps to Reproduce:
1. Open the ODS file in attachment 168721 [details].
2. Go to tab "Raw Data", select cell range A1:AD67920.
3. Ctrl+C to copy the selected data into clipboard.
--> 20s for copy operation to finish.

4. Resave the file as XLSX, and try to copy the same range using MS Excel.
--> 1s for the copy operation to finish.

Current Behaviour:
It take around 20s for the copy operation.

Expected Behaviour:
The data should be copied into clipboard within 1 or 2 seconds, as it is in Excel.

This is just one example - the size of the range is not that big. In fact in real case I usually have larger worksheets and the copy may take several minutes.

Version: 7.1.5.0.0+ / LibreOffice Community
Build ID: 8619e743564a241eb951866616aec82e1ab3965f
CPU threads: 4; OS: Linux 5.12; UI render: default; VCL: gtk3
Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN
Calc: threaded
Fedora 33 x64 with X11.
Comment 1 Kevin Suo 2021-06-23 03:50:48 UTC
Actually the slowness already exists in
Version: 5.4.0.0.alpha1+
Build ID: 9feb7f7039a3b59974cbf266922177e961a52dd1
Comment 2 [REDACTED] 2021-06-23 13:21:07 UTC
No repro - (copies almost instantly)

Version: 7.1.4.2 / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 3 Jean-Baptiste Faure 2021-08-11 12:41:38 UTC
Not reproducible for me with 

Version: 7.2.1.0.0+ / LibreOffice Community
Build ID: 3bec2da07a29029489257028adf77e52ad168906
CPU threads: 8; OS: Linux 5.11; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Ubuntu_20.04_x86-64
Calc: threaded

Best regards. JBF
Comment 4 BogdanB 2021-08-11 19:37:07 UTC
Very fast also in
Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: c97bdca2d7abf30a99c45192b8f49c5bf76ca035
CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded
Comment 5 Luboš Luňák 2021-12-07 07:41:07 UTC
I cannot reproduce either. Is this still valid with 7.3+?
Comment 6 Luboš Luňák 2022-02-20 08:31:14 UTC
No response, closing.