![]() ![]() 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. (You can see the result but not reproduce its creation with AOO, as already mentioned.I have now upgraded my operating system to Linuxmint 17 and Openoffice is now at 4.1.2. The example attached there was created copying charts together with the references and subsquently editing these. You may be interested in this recent thread in another forum. I cannot tell you for all the versions of ODF conformant software, but recent versions of LibreOffice do it the way you obviously expect if applicable (underlined case above). Only if it subsequently is pasted into the document from which it originated the chart's data references make sense (and might then be edited). Otherwise the references would need to change into external ones (very differently handled). To be able to paste a chart also into a different document not containing the data themselves (another Calc document, a Writer or a Draw/Impress document) it must be copied together with the data (contained in the chart's 'Data Table.' then). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |