Bug 65009

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