Bug 65009 - EDITING: Make it possible to disabled AutoCalculate for diagrams/charts too
Summary: EDITING: Make it possible to disabled AutoCalculate for diagrams/charts too
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.0.2.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2013-05-26 17:24 UTC by csongor
Modified: 2013-05-27 16:39 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments

Description csongor 2013-05-26 17:24:09 UTC
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
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,
Joren


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.