When a non-contiguous data range is specified for a chart (in Calc) then it no longer auto-updates.
===== Steps to reproduce
Create a new Spreadsheet (File -> New -> Spreadsheet)
Enter the following data:
- In cell A1: 1
- In cell A2: 1
- In Cell A3: 2
- In Cell A5: 3
Select cells A1:A3 and insert a column chart (Insert -> Chart... -> Finish)
Change cell A2 to 3 - <Result: chart updates as expected>
Double-click chart (to edit)
Right-click (on chart) -> Data Ranges...
Select "Data Series" tab and in the "Data ranges" section select "y-Values"
In the "Range for y-Values" field, change it to: $Sheet1.$A$1:$A$3, $Sheet1.$A$5
<Result: Chart updates to show 4 (four) columns as expected>
Close the "Data Ranges" dialogue (OK)
Click on any cell (to stop editing the chart)
Change cell A2 to 1 - <Result: chart does *not* update>
===== End of reproduction
Changing the Data Range back to the original (contiguous) selection ($Sheet1.$A$1:$A$3) does not remove the problem (the chart still does not auto-update).
The chart does update if the data range is modified, but it does *not* update when the data in the cells is changed.
If the spreadsheet is saved, closed and reopened, then the chart behaves normally (as expected). I.e. the chart auto-updates whether or not the Data range is contiguous or not. This bug only seems to appear on newly created spreadsheets.
FYI, I'm running:
LibreOfficePortable 3.3.2 (as from portableapps.com)
Windows 7 Professional x64
Not reproducible on LibreOffice 3.4 340m1(Build:12) on KDE OpenSuse Linux.
Thanks for the detailed instructions, Stephan. It made it very easy to reproduce the situation. However, after the step "Change cell A2 to 1", the chart does update. My chart still updates after closing the spreadsheet and reopening it. I did not try and change the data back to the original contiguous selection because the chart already responded when I changed the non-contiguous data.
Perhaps the problem was fixed in the later release? Can anyone confirm this?
I have a Calc document with a simple bar chart and *contiguous data*. When I close the spreadsheet, saving, then reopen it, if I then change Y data values, the chart does not update. Double-clicking the chart rectifies it, and thereafter it continues to update as required until the next time I open the document. I have this problem with various other documents which I have edited regularly until LibO 3.4.1 without problems.
I have tried creating a test document to replicate the problem in the simplest case, but failed on this, so the problem seems a little erratic. I expect this is a widespread problem, but you have to be watching the chart to realise when it does not update.
Note that the original post here had the problem rectified by save and reopen, whereas I find it is caused by save and reopen! The original post had the problem only with newly created sheets, whereas the similar problem I am describing is with existing sheets.
System: Windows 7 64-bit
Version: LibO 3.4.1 OOO340m1 (Build:103)
Note: I went direct from LibO 3.3.2 to 3.4.1
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
I couldn't reproduce the bug either with LibO 3.5.0 Win XP.
Marking as WFM. Feel free to reopen if you still can reproduce it with the latest version.
Matt> What you describe is a different bug. Please fill a new bug and post its number in the comments here in case other people find this one instead of yours.