Bug 121386 - LO Calc freezes when navigating in sheets
Summary: LO Calc freezes when navigating in sheets
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.3.2 release
Hardware: All All
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Performance
  Show dependency treegraph
 
Reported: 2018-11-13 10:24 UTC by perie_gut
Modified: 2023-04-12 16:53 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
sample file (650.86 KB, application/x-zip-compressed)
2018-11-13 10:24 UTC, perie_gut
Details
GSTR2_Matching_Format - Slow to open (3.22 MB, application/vnd.oasis.opendocument.spreadsheet)
2019-11-18 11:38 UTC, pharmankur
Details
LO uses 100% CPU and freezes for 30 - 40 min (107.41 KB, image/png)
2019-11-18 11:56 UTC, pharmankur
Details

Note You need to log in before you can comment on or make changes to this bug.
Description perie_gut 2018-11-13 10:24:49 UTC
Created attachment 146586 [details]
sample file

How to replicate the issue
1. extract the zip file
2. open the Report file
3. enable content to update the links
4. navigate "Header" Sheet
5. then navigate "account code" sheet
6. then navigate "actual" sheet. Worksheet Freeze.


LO Details 
Version: 6.1.3.2 (x64)
Build ID: 86daf60bf00efa86ad547e59e09d6bb77c699acb
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: en-PH (en_PH); Calc: threaded
Comment 1 Roman Kuznetsov 2018-11-13 12:42:00 UTC
don't repro in

Version: 6.2.0.0.alpha1+
Build ID: a20a2d7e0d28658f2d9089da076961a599833a28
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-11-12_22:51:20
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

but repro in

Version: 6.1.2.1
Build ID: 65905a128db06ba48db947242809d14d3f9a93fe
CPU threads: 4; OS: Windows 6.1; UI render: default; 
Locale: ru-RU (ru_RU); Calc: group threaded

Status-> NEW
Comment 2 Xisco Faulí 2018-11-13 13:28:30 UTC
testing it, I found bug 121388 on master...
Comment 3 Oliver Brinzing 2018-11-13 17:24:15 UTC
is this bug releated to:

https://bugs.documentfoundation.org/show_bug.cgi?id=120154
High RAM usage ( around 300mb for 10 mins and drop to 150-200 mb)

cause it has the same attachment
Comment 4 perie_gut 2018-11-13 22:08:34 UTC
I use the same spreadsheet file to test LO performance.. previously, I have never encountered this "freezing" even if LO consumes alot of memory...
Comment 5 Xavier Van Wijmeersch 2018-11-14 14:30:45 UTC
no repro just a bit slow to open, no freeze

step 6 after 25s the sheet is loaded
Version: 5.2.7.2
Build ID: 2b7f1e640c46ceb28adf43ee075a6e8b8439ed10
CPU Threads: 8; OS Version: Linux 4.19; UI Render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

step 6 after 40s the sheet is loaded
Version: 6.1.4.0.0+
Build ID: 17c87566e84ac433645f264a9bee4cb5ddbd23a5
CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group threaded

updating external links take a while about 40s but loading the page in step6
no delay

Version: 6.2.0.0.alpha1+
Build ID: eb9a223151a00d11ed89a42465663b6e5cd75bd9
CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 6 QA Administrators 2019-11-15 03:35:14 UTC Comment hidden (obsolete)
Comment 7 pharmankur 2019-11-18 11:38:33 UTC
Created attachment 155912 [details]
GSTR2_Matching_Format - Slow to open
Comment 8 pharmankur 2019-11-18 11:54:57 UTC
Using Mint 19.1  - Intel© Core™ i3-3110M CPU @ 2.40GHz × 2 | 6 GB RAM | 64 bit

LO Version: 6.3.3.2
Build ID: 1:6.3.3-0ubuntu0.18.04.1~lo1
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-IN (en_IN); UI-Language: en-GB
Calc: threaded


Calc takes more than 35 min to open a 3.4 MB file & also freezes for several minutes during use.
File has simple Vlookup arrays references for about 10000 rows and Conditional formatting.
Also tried to remove conditional formatting yet no improvement in speed.


How to reproduce- 

Download file - GSTR2_Matching Formatted.ods and try to open the same .... and once its open try to play around in the file / use filter etc. then it will suddenly freeze for 3-4 min ... 


Enclosing file - 1) GSTR2_Matching Formatted.ods
2) Screenshot of System Monitor (one of CPU always more than 100% for about 30 min in opening and for about 5 min while every small editing in file. Although RAM usage seems normal)
Comment 9 pharmankur 2019-11-18 11:56:02 UTC
Created attachment 155914 [details]
LO uses 100% CPU and freezes for 30 - 40 min
Comment 10 Telesto 2020-06-15 08:50:26 UTC
(In reply to pharmankur from comment #7)
> Created attachment 155912 [details]
> GSTR2_Matching_Format - Slow to open

Moved to a separate bug 133996
Comment 11 QA Administrators 2022-12-04 03:50:14 UTC
Dear perie_gut,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug