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]
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.