Bug 105499 - Editing of .ods calc document with many comments causes high CPU load, can crash on saving
Summary: Editing of .ods calc document with many comments causes high CPU load, can cr...
Status: RESOLVED DUPLICATE of bug 76324
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0 all versions
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-01-24 07:37 UTC by Patrik
Modified: 2020-03-10 19:50 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
testcase, calc with many comments (25.40 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-01-24 07:41 UTC, Patrik
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Patrik 2017-01-24 07:37:39 UTC
Description:
When a document as the attached, with many comments is opened then it can be edited normally for some time. After some mouse-overs on the many comments and some 15 seconds the document becomes sluggish and small edits like changing the column width take up a lot of time and CPU skyrockets. 

Editing a worksheet with many comments becomes actually impossible. Changing the format of many cells or showing/hiding of columns can take minutes while CPU/fan go crazy.

Sometimes LO crashes on saving, but only if the open worksheet is the one with the comments, switching to another allows saving.

Steps to Reproduce:
1.open example document
2.mouse-over some comments in the worksheet, wait some seconds
3.try resizing the column width, CPU of one core goes to 100% for half a minute 

Actual Results:  
hight CPU load on almost any edit

Expected Results:
normal CPU load, independent of number of comments in worksheet


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0
Comment 1 Patrik 2017-01-24 07:41:31 UTC
Created attachment 130650 [details]
testcase, calc with many comments

This bug was modeled after Bug 60418, after being told to open a new bug report, because the same behavior in calc is not the same as in writer. I mention this in case the code-base of comments might be similar and to make the history clear.
Comment 2 Buovjaga 2017-01-25 17:13:10 UTC
(In reply to Patrik from comment #0)
> Steps to Reproduce:
> 1.open example document
> 2.mouse-over some comments in the worksheet, wait some seconds
> 3.try resizing the column width, CPU of one core goes to 100% for half a
> minute 

Not seeing the skyrocketing.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.4.0.0.alpha0+
Build ID: 63fd4c97118a943c84ba5a666cf8c9cc54b511c7
CPU Threads: 8; OS Version: Linux 4.8; UI Render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on January 22th 2016
Comment 3 Buovjaga 2017-01-25 17:22:01 UTC
Áron pointed out that there is already a matching report. I will mark this as duplicate.

However, even the test file in bug 76324 does not cause me problems.

*** This bug has been marked as a duplicate of bug 76324 ***
Comment 4 b. 2020-03-10 19:50:58 UTC
hi, 

comments (notes, post-it's, captions) are! an issue, since years, and 76324 is the main bug for it, but making very little progress ... (it's too long for developers to read and recheck ) 

the provided sample has only about 250 comments, that shouldn't be a problem on recent hardware, but bigger amounts definitively are. 

there have been - accidental? - improvements in ver 6.2.7.1 and 6.2.8.2, win!, lin was still very slow. theese improvements seem to 'fade out' in 6.3, 6.4, 6.5 and 7.0 versions :-( 

i suggest using the 6.2 versions for files with plenty comments, be careful, they are not robust regarding parallelized computing, 'openCL' or 'threaded' enabled produces errors (needing hard recalc). 

if anybody knows how to find someone with skills to work an this annoying problem i'd appreciate it very much, this bug is already affecting fun with the program for too long time. 

reg. 

b.