Bug 38734 - [Chart] Auto update breaks with non-contiguous data range
Summary: [Chart] Auto update breaks with non-contiguous data range
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected)
3.3.2 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2011-06-28 00:53 UTC by Stephan Zietsman
Modified: 2012-11-22 08:32 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Stephan Zietsman 2011-06-28 00:53:21 UTC
When a non-contiguous data range is specified for a chart (in Calc) then it no longer auto-updates.

=====  Steps to reproduce

Open LibO
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

Some observations:
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.

Puzzling behaviour:
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.
Comment 1 Stephan Zietsman 2011-06-28 00:57:08 UTC
FYI, I'm running:
LibreOfficePortable 3.3.2 (as from portableapps.com)
Windows 7 Professional x64
LibreOffice 3.3.2 
OOO330m19 (Build:202)
tag libreoffice-
Comment 2 Jeffrey 2011-06-28 01:26:52 UTC
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?
Comment 3 Matt 2011-07-05 15:00:08 UTC
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)
Comment 4 Matt 2011-07-05 15:02:59 UTC
Note: I went direct from LibO 3.3.2 to 3.4.1
Comment 5 Björn Michaelsen 2011-12-23 12:27:05 UTC
[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
Comment 6 Thomas Bertels 2012-03-20 04:22:15 UTC
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.