Bug 140477 - FILEOPEN A certain ODS file slow to open
Summary: FILEOPEN A certain ODS file slow to open
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks: File-Opening
  Show dependency tree / graph
 
Reported: 2021-02-17 15:24 UTC by Constantine J. Aivalis
Modified: 2022-06-25 08:16 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Attachments
Student list with grades (64.91 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-02-17 15:25 UTC, Constantine J. Aivalis 		Details
perf flamegraph (45.06 KB, application/x-bzip)
2021-02-18 17:23 UTC, Julien Nabet 		Details
bt at random (17.45 KB, text/plain)
2021-02-18 17:32 UTC, Julien Nabet 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Constantine J. Aivalis 2021-02-17 15:24:29 UTC 
Description:
Early version 7.1.0 Calc application will not open the .ods file i created and have been using without problem with version 7.0.4.2(x64).

Tried several times and Calc 7.1.0 always hangs. Also in Safe Mode. 

Steps to Reproduce:
1.Try to open attached ods.



Actual Results:
System hangs for ever

Expected Results:
Should have loaded the spreadsheet


Reproducible: Always


User Profile Reset: Yes



Additional Info:
The ods file includes greek characters and very few simple calculations
Comment 1 Constantine J. Aivalis 2021-02-17 15:25:26 UTC 
Created attachment 169830 [details]
Student list with grades
Comment 2 Xisco Faulí 2021-02-18 09:53:18 UTC 
Reproduced in

Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: cbcec4425e04e3614a2025b49fdc221216ac51d3
CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 3 Xisco Faulí 2021-02-18 09:55:05 UTC 
I tried to bisect it and it points me to https://cgit.freedesktop.org/libreoffice/core/commit/?id=07379e0eb27de0c16ae3838532310aa5aec4f20f... not sure whether it's related at all...

@Julien, would it be possible to have a perf graph for this issue ?
Comment 4 Julien Nabet 2021-02-18 17:23:55 UTC 
Created attachment 169872 [details]
perf flamegraph

On pc Debian x86-64 with master sources updated today, I could reproduce this.
I used gen rendering and enable-symbols (not enable-dbgutil).

I waited about 30/40 seconds after having launched the opening of the file and there were only 4 or 5 squares in the progress bar (so I suppose less than 5% ?).
Comment 5 Julien Nabet 2021-02-18 17:32:54 UTC 
Created attachment 169873 [details]
bt at random
Comment 6 Buovjaga 2022-05-12 11:53:16 UTC 
Still the same

Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 32714f966186d301435d3eb9f7f6950bc9a6bb1e
CPU threads: 8; OS: Linux 5.17; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Comment 7 Roman Kuznetsov 2022-06-19 22:12:20 UTC 
LO opens it for 40 sec in

Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: e4d23c27288b99c3ed3cfa332ff308b31c01f97d
CPU threads: 4; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: ru-RU (ru_RU.UTF-8); UI: en-US
Calc: threaded Jumbo

There is a some progress here...
Comment 8 Constantine J. Aivalis 2022-06-20 09:11:45 UTC 
I had this problem only with 7.1.0 early version. The problem has been solved with all recent versions. Both early and stable. Thank you! Libre-Office is an excellent application!
Comment 9 Luboš Luňák 2022-06-25 08:16:14 UTC 
Closing according to comment #8.