Apache OpenOffice (AOO) Bugzilla – Issue 83762
Autocalculate function work not correct
Last modified: 2017-05-20 11:28:09 UTC
It looks like that the Autocalculate function are not work correct. Example: Create a Chart, disable Autocalculate and change the datarange. Chart will be updated.
Confirmed this behaviour in OO 2.3 on WinXP. But is this really a defect? I don't think so. Why can't chart cells be different thant regular cells ??
Well, I think the idea of auto-calculate is, that you can disable it when you enter lots of data, and update takes long, so you want to disable it, enter your data, and then re-enable it again. As updating charts takes usually longer than updating a formula, I think it would make sense to suppress chart updates, too. ->NN: What do you think? It should be sufficient not to send change notifications to the data sequences. The question is, what happens when the chart is double-clicked? With no more ado, I think you would get the old values displayed, and once you do a change inside the chart, you get the new data. So, it would be wise to send a delayed modify event to the chart when activated.
Not finished in time for 2.4, retargeting.
Reset assigne to the default "issues@openoffice.apache.org".