Ask Your Question
0

Chart does not update when cell content change

asked 2015-07-10 12:18:22 +0200

Lionel Lagarde gravatar image

updated 2015-08-24 20:16:17 +0200

Alex Kemp gravatar image

Hi,

I have an annoying problem using libre office calc (4.4.3.2 Windows 7).

I have a spreadsheet containing a lot of sheets. Each sheet has the same format: some data and some XY charts. A few times a day, a new set data comes. I duplicate an existing sheet and paste the new data.

Often, when I duplicate a sheet, the source and destination charts get disconnected from the sheet cells. The 'Data range' contextual menu is replaced by 'Chart data table' and pasting or setting new values in the cell does nothing.

Sometimes, the 'Data range' contextual menu remains here but the chart doesn't update as well. I have to move the chart on the sheet to force the update.

I don't know if there is something I'm doing wrong of if it's a bug.

Toughs ?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2015-07-10 17:33:19 +0200

Lionel Lagarde gravatar image

updated 2015-07-10 18:02:37 +0200

It seems that the version 4.4.4.3 has solved the 'Data range' problem.

But it has been replaced by another one. The duplicated charts reference the duplicated cells but the curves are the same as the source sheet. If I change a value in a cell, the chart does not update. If I edit the chart (Edit mode) the curves are updated according to the new values. If I leave the Edit mode, the chart goes back to previous state (identical to the source chart).

If I move the chart (few pixels) on the sheet, the curves are updated. If I change another value, the chart if not updated. I have to move again the chart to see the new curves.

The Ctrl/Shift/Alt F9 shortcuts does nothing.

edit flag offensive delete link more

Comments

I'm having the same problem with LibreOffice 5.3.3.2 on Linux. It's annoying me too.

GeorgeRamsower3 gravatar imageGeorgeRamsower3 ( 2017-06-22 19:11:52 +0200 )edit

Bad: -1- New problem in old thread.
-2- No question, but a complaint.
Was this issue ever reported to bugs.documentfoundation.org?

Lupp gravatar imageLupp ( 2017-11-09 10:19:40 +0200 )edit
0

answered 2017-11-09 08:30:38 +0200

updated 2017-11-09 08:37:09 +0200

I have the same issue as Lionel with version: 5.3.6.1 (x64). I had to open the sheet in safe mode and save it there and then it seemed to work fine.

EditSimply saving, closing and reopening seems to have a similar effect.

edit flag offensive delete link more

Comments

This is a different problem (the problem of OP was solved long ago). Your issue seems to be https://bugs.documentfoundation.org/s... (fixed in upcoming releases)

Mike Kaganski gravatar imageMike Kaganski ( 2017-11-09 09:17:53 +0200 )edit
Login/Signup to Answer

Question Tools

3 followers

Stats

Asked: 2015-07-10 12:18:22 +0200

Seen: 1,970 times

Last updated: Nov 09 '17