Bug 65009 - EDITING: Make it possible to disable AutoCalculate for diagrams/charts too
Summary: EDITING: Make it possible to disable AutoCalculate for diagrams/charts too
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: Chart Calculate
  Show dependency treegraph
Reported: 2013-05-26 17:24 UTC by csongor
Modified: 2021-08-11 13:58 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description csongor 2013-05-26 17:24:09 UTC
Problem description: 

Steps to reproduce:

make a small spreadsheet. For example:
A1: 1
A2: =2*A1

Create a diagram from the two cells. That is, select them and apply Insert => Chart menu item and finish it by the Finish button.

Got to cell A1 by clicking on it.

Disable Autocalculation by removing the tick from the menu item under Tools => Cell Content => AutoCalculate

Change A1 from 1 to 10. Check if Autocalculation is really off: A2 remains 2 instead of changing to 20. That's OK.

Current behaviour:
The diagram is changing to indicate values 10 and 2.

Expected behaviour:
The diagram should not be refreshed and should indicate the original values 1 and 2.

Explanation: in case of having diagram that depends on huge amount of cells, well, it requires pretty much CPU time to refresh the diagram. I suppose the goal of disabling AutoCalculation is to avoid repeated background calculation and make the editing more comfortable. The fact that diagrams are recalculated in case of each cell modification breaks the work.

That's why I think diagrams should not be refreshed if AutoCalculation is switched off. Or, at least, it should be possible to switch off diagram recalculation in a separate menu item. 

Operating System: Windows 7
Version: release
Comment 1 Jorendc 2013-05-27 16:39:43 UTC
Thanks to our Core developer Markus I can mark this as an enhancement request, not a bug. This isn't implemented yet in 'AutoCalculation'.

Kind regards,
Comment 2 stragu 2021-08-11 13:58:46 UTC
Reproduced in a recent master build:

Version: / LibreOffice Community
Build ID: b2130ad3fda841c68a0436fbddf29bcedede0af5
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-08-09_13:03:07
Calc: threaded

The option to turn off AutoCalculate is now at a different spot: Data > Calculate > AutoCalculate