Problem description: Steps to reproduce: 1. make a small spreadsheet. For example: A1: 1 A2: =2*A1 2. Create a diagram from the two cells. That is, select them and apply Insert => Chart menu item and finish it by the Finish button. 3. Got to cell A1 by clicking on it. 4. Disable Autocalculation by removing the tick from the menu item under Tools => Cell Content => AutoCalculate 5, 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. Thanks. Operating System: Windows 7 Version: 4.0.2.2 release
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, Joren
Reproduced in a recent master build: Version: 7.3.0.0.alpha0+ / 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