In Calc, when Data->Calculate->AutoCalculate is off, nothing is displayed in UI to the user to inform about that. A visual clue would be useful to reduce confusion when users can't understand why the data displayed in cells doesn't follow the dependent data; or to avoid situations when users think that data is updated. A status bar icon, e.g. next to "file modified" icon, telling "Data changed -Recalc is needed", could do the trick I suppose.
Created attachment 154717 [details] test_sum.ods Due to disabled auto calc attached spreadsheet shows value 6 in cell B3 instead of 15. But without option "Recalculation on File load: [Always recalculate]" the spreadsheet will not update. e.g. this could be the root cause for issue "Bug 127800 - Libreoffice does not recalculate sum"
Would be a nice addition to the statusbar. The to-be-drawn icon could be disabled or not depending on the state.
Hi Heiko, even better if a double click on the it does the recalculation. And too much if clicking on it the same options than in Menu/Data/Calculate appears.
Well, let's be carefully with the interaction. We should definitely have a context menu with on/off, and both recalc functions but I would abstain from double click as this could be unintended. Double-click (execution of functions) is in general very uncommon at the status bar. Anyway, let's go with the status bar solution.
Heiko Tietze committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/a0db0bd2e8558bfd1b2f7491a90221280f4a38d0 Resolves tdf#127937 - Feedback for AutoCalculate It will be available in 25.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.