Created attachment 52779 [details]
reproduced problem in sample file
Problem description: When spreadsheet on foreground with switched off AutoCalculate + there are some cells with Conditional Formatting and date values, very high CPU load can be seen everlasting.
For simplicity I've created simple scenario (in reality I have complex document and conditional formatting is only in the first column).
Steps to reproduce:
1. Create new Calc / Spreadsheet document
2. set A1 =TODAY()
3. set B1 .. K1 = A1+1 .. J1+1
4. copy row 1 to rows 2 ..40
5. set on this (A1..K40) cells the conditional formatting:
[x] Condition 1: Cell value is equal to TODAY()
6. set Tools / Cell Content / [ ] AutoCalculate
Current behavior: very high CPU load: 30-100% without any user input
Expected behavior: minimal CPU load (0-1%)
Platform (if different from the browser): probably on all platforms (at least on linux and windows). this bug is also in older versions (at least 2 years ago)
I confirm this behaviour with version 3.4.3 on a Windows platform.
Re-enabling the autocalculate brings back the processor load to minimal.
Because of confimation of Winfried
(In reply to comment #2)
> Because of confimation of Winfried
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":
prevent 100% cpu on switched of autocalc with volatile func, fdo#42260
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.