https://bugs.documentfoundation.org/show_bug.cgi?id=153766
--- Comment #2 from ady <adylo811...@gmail.com> --- > This is happening in current master and back to 3.5, so my guess is this > could be an old performance workaround. There is one thing to consider. IIUC, CF works "somewhat" like volatile functions, so it may demand more calculation resources in some sense. There was a time when users would make changes to a workbook, and only then would activate calculation (whether automatic or manual). Nowadays, most "normal" size worksheets (if there is such a thing) are used with AutoCalculate set on, whereas "big" workbooks are calculated manually in order not to waste time waiting for some meaningless calculation, until the results are really needed. Setting conditional format to disregard the Calculate setting could be detrimental for such "big" size workbook users that intentionally set AutoCalculate to off. IDK whether CF deserves its own "AutoCalculate" setting, but that seems a possible way to allow users control their resources according to their needs and priorities, instead of imposing one way or the other. The additional factor to consider would be the potential discrepancy between the way a cell "looks" (CF) and the (not-yet-calculated) results somewhere in the worksheet. -- You are receiving this mail because: You are the assignee for the bug.
