Calc chart not refreshing when data changes _Latest_Update

[Ronald_Duncan]

This bug is still around was reported back in Nov 14. However the answer press F9 does not work in LibreOffice 24.2.0.3.

Calc chart not refreshing when data changes

I have a 5-sheet 4Mb spreadsheet with many lines of data, from which I select one line with VLOOKUP functions to create a table that is used to drive a pair of charts to display the selected data. Select a new data line, the table changes and the charts should change. This was working (and I’ve used the approach before on MS EXCEL quite happily). Currently I can change the data and see the change in the data table, but the charts do not update - they are holding the previous charts’ data. No o…

The solution is CTL + SHIFT + F9

Another example of this bug

Chart does not update when data is updated

Bugs #86321 #136160 #136254 have been created specifically for this topic. Still reproducible up to an including Version: 7.1.0.0.alpha0+ Build ID: f08ddf3d3df0ef12fef36e96ffe6f5b9a7fda9e3 Readers busy building spreadsheets (like me): some laborious workarounds that may (sometimes) help (while waiting for a debugged version) - Click on the chart and dragging it a few pixels will cause it to update. Zoom out (then in) the whole sheet view (using mousewheel if you have one) may work. Copy t…

Edited to add in links to previous examples

[mikekaganski]

@Ronald_Duncan

This bug

Which is “this”? Please don’t forget to provide a link, when you refer to something.

@Ronald_Duncan

the answer press F9

Which “the answer”? Please don’t forget to provide a link, when you refer to something. I guess, that the answer would likely tell that F9 refreshes the selected cell. Chart isn’t a cell.

[Lupp]

LibO V24.2.0 was an “extremely fresh” version. There may have been a few bugs (regressions) introduced during the implementation of new features and not detected and fixed in advance of the release.
If you don’t feel to be an expert, you should better use a “rather still” version like V 7.6.6.3 currently.

[Ronald_Duncan]

Sorry this previous bug. I have updated the question to include the link.

Calc chart not refreshing when data changes

I have a 5-sheet 4Mb spreadsheet with many lines of data, from which I select one line with VLOOKUP functions to create a table that is used to drive a pair of charts to display the selected data. Select a new data line, the table changes and the charts should change. This was working (and I’ve used the approach before on MS EXCEL quite happily). Currently I can change the data and see the change in the data table, but the charts do not update - they are holding the previous charts’ data. No o…

and added in a link to

Chart does not update when data is updated

Bugs #86321 #136160 #136254 have been created specifically for this topic. Still reproducible up to an including Version: 7.1.0.0.alpha0+ Build ID: f08ddf3d3df0ef12fef36e96ffe6f5b9a7fda9e3 Readers busy building spreadsheets (like me): some laborious workarounds that may (sometimes) help (while waiting for a debugged version) - Click on the chart and dragging it a few pixels will cause it to update. Zoom out (then in) the whole sheet view (using mousewheel if you have one) may work. Copy t…

[mikekaganski]

OK. Let us please try not to bring together very different things.

There was an issue of a user who disabled auto-calculation. It was not a bug, and F9 for the current not updated cell (or Ctrl+Shift+F9 for everything in the file) helped in that case (or simply enabling the automatic calculations).

There was tdf#86321, fixed in 7.0.6, which manifested by correct display in edit mode.

But it is still unclear what happens in your case. You say that Ctrl+Shift+F9 helps; so maybe you have automatic calculation disabled? Or is that something else - maybe a completely new problem?

[Ronald_Duncan]

Thanks,
In my case I have two tables of data, with a number of rows that are used in their respective charts.

I have had the problem before of the charts not updating when I changed the underlying data, and it solved when I changed the size of the chart.

The master table has years and a breakdown of the carbon footprint for the year, followed by a forecast. My update was to change the most recent forecasted year to an actual year by creating a new tab with the actual details, and then replacing the formulae in the table to point to this new tab.

I then noticed that the charts had not updated. I went into edit the chart played around with the range and other things to try and get the chart to refresh.

Then I went through searching for solutions and found the first link, which when I read through mentioned CTL + SHIFT + F9, which solved the problem for me and gave me the updated chart that I was able to copy into a report.

I checked my settings and Autocalculate is on. I have never changed it for LibreOffice (In excel when working on very large models, I used to turn it off about 20 years ago but have not needed to with modern PCs)

It is a pretty simple workbook total size 50.7Kb, so easy to share if that would help.

[mikekaganski]

Aha, so that is all very important missing bits of information, that a chart copied together with its data sheet will not listen to the data changes, until updated forcefully. Not very useful to post the data here - but it would be very useful to report that as a bug (and be sure to post the sample there). Only then will you enable developers to discover the problem, and give them a chance to fix it (and no amount of users sharing workarounds on this Ask site make that moment any closer).

[mariosv]

Maybe tdf#121626

[Ronald_Duncan]

Thanks,
It was different. I have a summary sheet, with a detailed table and highlevel summary table along with corresponding charts.

The summary table was not changed just the detailed table. By copying one of the calculation tabs, updating it and then changing the formulae in the detailed table to point to the new calculation tab.

The both charts would not update. It tried various edits to the detailed chart with no success and then both charts updated when I pressed CTL + SHIFT + F9

[Ronald_Duncan]

I have been testing as part of creating a bug report. The chart updates fine if I just make data changes. The thing that stops the chart updating is duplicating one of the existing Year worksheets.

I have year worksheets with details and a summary worksheet with tables that refer back to the year worksheets and charts based on the tables.

Duplicating a year worksheet causes the chart to stop updating.

[Ronald_Duncan]

Created bug report with example workbook
https://bugs.documentfoundation.org/show_bug.cgi?id=160607

[Ronald_Duncan]

Bug has been confirmed in 7.2.5.1 may have been around for a while.