![]() ![]() I just found a new wrinkle to the graphs-fail-to-update problem as I was entering new data to the spreadsheet today. I midstream file automatically every 20 minutes and manually file sometimes too, so graphs failing to update for simply filing is unacceptable. I re-opened the spreadsheet with Libreoffice and all the graphs display correctly. Thanks for your suggestion coray80 but that's not it. I hope this can help someone figure something out. If I double-click on any of the un-updated graphs the new data shows correctly but when clicking outside of the graph to get out of editing mode, the graph reverted to the un-updated state. The graphs that failed to update remained un-updated. After the new data was entered for all the graphs that didn't update, I filed again. I went back and looked at the graphs that were previously updated correctly and they were still updated correctly. After the spreadsheet was filed the next new data I entered and on every graph that I entered new data for failed to update the graphs. After a while I decided to file to make sure that the operations I had already entered were saved. As I was entering new data this morning the graphs were updating correctly, every one. I just found a new new problem that may lead to a solution to fix the graphs-fail-to-update problem. If there is a programmer out there who is working on this problem, I'd be happy to help test and debug a possible solution. I have also went as far as recreating all the charts and that seemed to work as long as I worked during that session, but the problem always comes back again the next time the file is opened. I never use windows so I don't know if it also has the problem. I also can run Openoffice on my Mac laptop and it has the same chart-fails-to-update problem as the Linux system. I then use openoffice to make the changes I couldn't make with Libreoffice, file, then re-open the spread sheet with Libreoffice and everything works fine from then on. I prefer to use openoffice because one problem with updating Libreoffice charts is that a chart copied from one sheet to another and when the data ranges are modified that action sometimes kills the whole Libreoffice program and it's annoying to have to go through the recovery process. ![]() I can take that same spread sheet file with Libreoffice(4.2.8.2) and when I updata the data the charts are updated correctly everytime. If I save the file and then re-open it the graph correctly displays the new data, and if I double-click on the chart it still shows the data correctly and when I click outside of the graph it is still correct. If I double-click on the chart it shows the new data correctly, but when I click out of the chart it reverts to the old version. Normally, I would expect that when the new weeks' data is added in the spread sheet by removing the top row and adding the new data to the bottom row, the chart would reflect the change, but it doesn't. When a new weeks' data is available the first week's data on the left side of the chart is replaced by the second weeks' data, and the new weeks' data is added on the right end of the line chart. ![]() ![]() There are always 52 data points on the X axis, one for each week of the year. I have a line chart that tracks a stock price weekly. Please let me describe the way the probem exists. The same problem with charts not updating persists as before. I have now upgraded my operating system to Linuxmint 17 and Openoffice is now at 4.1.2. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |