Bug 163588 - Slow copying in an XLSX file with lots of direct formatting
Summary: Slow copying in an XLSX file with lots of direct formatting
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.0.3 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks: Performance
  Show dependency treegraph
 
Reported: 2024-10-23 10:08 UTC by seven
Modified: 2025-06-25 13:48 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Excel file (1.17 MB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-10-23 10:09 UTC, seven
Details
Sample file after cleaning all columns beyond the data. (2.01 MB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-10-23 21:23 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description seven 2024-10-23 10:08:35 UTC
Description:
The excel file contains some changes to 16-thousand rows and several columns, which affects the performance of navigation, copying to buffer, deleting and so on.

Steps to Reproduce:
1. Open file in attachment
2. Try to do copy, paste, delete, navigate operation and control speed

Actual Results:
Almost all operation doing slow

Expected Results:
All doing fast


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 24.8.2.1 (X86_64) / LibreOffice Community
Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
CPU threads: 20; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: CL threaded
Comment 1 seven 2024-10-23 10:09:49 UTC
Created attachment 197201 [details]
Excel file
Comment 2 m_a_riosv 2024-10-23 21:23:19 UTC
Created attachment 197211 [details]
Sample file after cleaning all columns beyond the data.

Seems there is something on the columns beyond data, possibly a direct format.
After selecting all columns beyond data, the file works fine.
Comment 3 BogdanB 2025-01-01 14:28:43 UTC
When opening this file in debug version of LibreOffice, I am getting:
warn:vcl:9005:9005:vcl/source/window/dndeventdispatcher.cxx:185: rejecting drag over due to missing listeners.
warn:vcl:9005:9005:vcl/source/window/dndeventdispatcher.cxx:185: rejecting drag over due to missing listeners.
warn:vcl:9005:9005:vcl/source/window/dndeventdispatcher.cxx:185: rejecting drag over due to missing listeners.
warn:vcl:9005:9005:vcl/source/window/dndeventdispatcher.cxx:185: rejecting drag over due to missing listeners.
warn:xmloff:9005:9005:sax/source/fastparser/fastparser.cxx:1233: unknown attribute revIDLastSave=0
warn:xmloff:9005:9005:sax/source/fastparser/fastparser.cxx:1233: unknown attribute documentId=13_ncr:1_{95DA07AC-1979-4B5D-A46B-A0EADC0187E9}
warn:xmloff:9005:9062:sax/source/fastparser/fastparser.cxx:1233: unknown attribute defaultSlicerStyle=SlicerStyleLight1
warn:xmloff:9005:9062:sax/source/fastparser/fastparser.cxx:1233: unknown attribute defaultTimelineStyle=TimeSlicerStyleLight1
warn:oox:9005:9066:oox/source/helper/progressbar.cxx:67: ProgressBar::setPosition - invalid position
warn:oox:9005:9066:oox/source/helper/progressbar.cxx:67: ProgressBar::setPosition - invalid position
warn:oox:9005:9066:oox/source/helper/progressbar.cxx:67: ProgressBar::setPosition - invalid position

Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: f24bb80e45c1693db33b47ee695436b2c8d5fbcd
CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded
Comment 4 Buovjaga 2025-06-25 13:48:11 UTC
I only reproduce a lag of some seconds when copying. Deleting and pasting are instant. I don't know what navigation means in this case, but scrolling works fine.

The lag in copying appears together with the addition of support for 16,384 columns (in 7.5), so that would be in line with comment 2.

Arch Linux 64-bit
Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 070732f622ac54f940f41d7d80883a2385725111
CPU threads: 8; OS: Linux 6.15; UI render: default; VCL: gtk3
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: CL threaded
Built on 25 June 2025