Bug 153630 - FILEOPEN, UI, Bad Performance when open specific .xlsx Table
Summary: FILEOPEN, UI, Bad Performance when open specific .xlsx Table
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.5.1 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks: File-Opening
  Show dependency treegraph
 
Reported: 2023-02-15 07:29 UTC by martin.sickfeld
Modified: 2023-05-17 13:27 UTC (History)
2 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 martin.sickfeld 2023-02-15 07:29:08 UTC
Description:
When I try to work with Lenovos Accessories and Options Compatibility Matrix (OCM), LO will get unresponsible and it tooks much to long to open the Table:
https://download.lenovo.com/pccbbs/options_iso/ocm_feb_2023.xlsx
This happen on several Platforms and LO Versions.
Excel, OnlyOffice and WPS Office don't have this behaviour.
After converting the .xlsx (7,9 MB) to .xls (37,6MB) or .ods (3MB) it seems to be no problem at all.


Steps to Reproduce:
1.Download File from Lenovo
2.Try to open in calc
3.

Actual Results:
LO open the file after more than 2 minutes and working with the Table is nearly impossible.

Expected Results:
Open quickly and UI should stay responsible


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.4.5.1 / LibreOffice Community
Build ID: 40(Build:1)
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Ubuntu package version: 1:7.4.5-0ubuntu0.18.04.1~lo1
Calc: threaded
Comment 1 m_a_riosv 2023-02-15 14:43:31 UTC
Reproducible
Version: 7.5.1.1 (X86_64) / LibreOffice Community
Build ID: bd819218336a5be54a11b986ea4dd2db2efb120e
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded 
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 9788a565b3241d1bd62394b9e29c322361d05f80
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Jumbo

Maybe it has to do with a lot of direct format in the columns beyond data, and hundreds of styles.

Excel takes a lot of time saving in ods format.