Ask Your Question

calc resize chart to update it

asked 2019-06-01 17:21:28 +0200

Begtech gravatar image

This problem has been around for a LONG time, in many versions of LibreOffice. I just upgraded to a clean version of LibreOffice (64) on my Windows 7 machine, and still need to move or resize my charts to get them to update. I've tried F9 and <cntl><shift>F9 and whatever other key combinations I could think of and have never been able to get the chart to update without sliding it around a bit.

My spreadsheets are large and complicated, with one sheet feeding another sheet to do calculations, and that sheet feeding graphs on yet a third sheet. Perhaps the way I set them up is the root of the problem. Perhaps the problem is associated with using a spreadsheet made several generations ago?

Are other users still having this problem, or do I need to somehow redo my spreadsheets to make it go away?

Hardware is dell precision T1500 with NVidia Quadro 4000 graphics card.

edit retag flag offensive close merge delete


Partial solution--tools;options;LibreOffice;view;Use OpenGL for all rendering. Turning on OpenGL reduced the incidence of non-update greatly. I have one graph this morning that will not update a label until dragged, but other than that it has worked flawlessly, even with graphs using data from multiple sheets and which were copied and pasted within the same sheet they were created on. More testing to follow.

Begtech gravatar imageBegtech ( 2019-06-03 15:11:09 +0200 )edit

I'm also having the same problem. OpenGL didn't completely fix the problem although it helped a bit. I also noticed the cutting and repasting the graph in the same place works to update it. Also saving and reopening the file works too. Neither are convenient.

Arctos31 gravatar imageArctos31 ( 2020-04-27 22:57:40 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-06-02 15:04:30 +0200

geogre gravatar image

I am having the same problem. It is really annoying. I have to save + close Calc and have to reload to see changes in data represented in the associated chart. But this is not the way it used to be. I have been using the file in question for many years, some of the charts in use had been copied and pasted from others and are displaying different data. It just started this annoying behaviour some weeks or months ago (can't really say).

edit flag offensive delete link more


I have just tried turning on OpenGL. At first glance, this seems to help. But I can not say yet by how much. At the first moment I was a bit startled though, because the charts looked quite different, mainly regarding the line widths.

geogre gravatar imagegeogre ( 2020-06-02 15:11:18 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-01 17:21:28 +0200

Seen: 52 times

Last updated: Jun 02