Bug 127937 - Provide feedback of AutoCalculation at the status bar
Summary: Provide feedback of AutoCalculation at the status bar
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Statusbar
  Show dependency treegraph
Reported: 2019-10-02 20:48 UTC by Mike Kaganski
Modified: 2019-10-10 07:24 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

test_sum.ods (8.52 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-10-03 07:14 UTC, Oliver Brinzing

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2019-10-02 20:48:55 UTC
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.
Comment 1 Oliver Brinzing 2019-10-03 07:14:08 UTC
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"
Comment 2 Heiko Tietze 2019-10-08 12:24:50 UTC
Would be a nice addition to the statusbar. The to-be-drawn icon could be disabled or not depending on the state.
Comment 3 m_a_riosv 2019-10-09 20:20:41 UTC
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.
Comment 4 Heiko Tietze 2019-10-10 07:24:53 UTC
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.