Bug 123529 - High CPU when scrolling in a calc sheet with lots of comment indicators
Summary: High CPU when scrolling in a calc sheet with lots of comment indicators
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.0.1 rc
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, regression
Depends on:
Blocks: Calc-Comments Scrolling-PageUpDown
  Show dependency tree / graph
 
Reported: 2019-02-17 20:07 UTC by Telesto
Modified: 2019-06-07 17:28 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Example file (36.78 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-02-17 20:07 UTC, Telesto 		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 Telesto 2019-02-17 20:07:40 UTC 
Description:
High CPU when scrolling in a calc sheet with lots of comment indicators

Steps to Reproduce:
1. Open the attached file
2. Scroll up down/ left right & monitor CPU


Actual Results:
Full utilization 

Expected Results:
Same as 6.0.2


Reproducible: Always


User Profile Reset: No



Additional Info:
Found in
Version: 6.3.0.0.alpha0+
Build ID: e0745a11597e5d57eb8001a295314e86810a6027
CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-02-12_04:16:22
Locale: nl-NL (nl_NL); UI-Language: en-US
Calc: CL

but not in
Version: 6.0.2.0.0+
Build ID: 55b37cc3ade30257858515b1a062ff9130488a5f
CPU threads: 4; OS: Windows 6.3; UI render: default; 
Locale: nl-NL (nl_NL); Calc: CL
Comment 1 Telesto 2019-02-17 20:07:56 UTC 
Created attachment 149359 [details]
Example file
Comment 2 Telesto 2019-02-17 20:17:59 UTC 
Not with
Version: 6.1.0.0.beta2+
Build ID: 033400a7524813b4eccf8f90a7647bc0121e75dd
CPU threads: 4; OS: Windows 6.3; UI render: default; 
Locale: nl-NL (nl_NL); Calc: CL

but with 6.2
Comment 3 Xisco Faulí 2019-04-16 08:44:40 UTC 
CPU is always below 50% while scrolling in

Version: 6.3.0.0.alpha0+
Build ID: 033e1130a65ec7f0fa9c46e5124adc9d8bf724ba
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded

Could you please try to reproduce it with a master build from http://dev-builds.libreoffice.org/daily/master/ ?
You can install it alongside the standard version.
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the master build
Comment 4 b. 2019-05-30 19:19:55 UTC 
@xisco: reg. comment #3

xisco, are you kidding? 

this user has about 5,2k comments in the demo, 

it's know since 2014! that calc has massive performance problems with comments, 

see #76324, 

wouldn't it be fair to tell affected users: 

---------------------------------------------------------------------
yes: we know there are massive performance issues with comments in calc, 

no: we didn't find time to fix it yet, 

no: we can't raise the priority or work on it while we have few programmers and bigger issues, 

workaround: avoid or reduce the use of comments
---------------------------------------------------------------------
Comment 5 Telesto 2019-06-07 17:28:35 UTC 
Looks OK
Version: 6.4.0.0.alpha0+ (x64)
Build ID: 95462a02a3aee1e3e7f9aa8fc50ba25fee3fa592
CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-06-03_07:09:38
Locale: nl-NL (nl_NL); UI-Language: en-US
Calc: CL