Apache OpenOffice (AOO) Bugzilla – Issue 78086
new Chart: charts no longer update
Last modified: 2013-02-24 21:21:10 UTC
When I started using OOo-Dev_SRC680_m213_LinuxIntel_install.tar.gz last week, all my charts stopped updating. In a spreadsheet with 2 or more sheets; tables of numbers on sheet1, and chart on sheet2. etc. Correct behavior, as verified with v2.2.0-rc2 enter number in sheet1, sheet2 chart updates immediately. Current bad behavior in m213: enter numbers, chart is static, and has Not updated since last week, despite daily updates and FileSave sequences. IF I press F9, then the y-axis scale resets to minimum = 0, with different tick intervals. If I edit the chart to reset the y-axis, I verify it is set to automatic. But it is not calculating correctly. Thus the higher priority IMHO. Also, If I Edit the chart without pressing F9, the same reset occurs, and the chart does update. Regarding the y-axis scale, Editing with 2.2.0 gives good values: min,max,maj,minor,axis of 32.5,62.5,2.5,1.3,32.5 (Automatic), but editing with m213 results in: 0,70,10,2,0 (Automatic). Stewart
Created attachment 45636 [details] example for 78086. temperature chart ods
additional info: I notice the minor interval is no longer accepting fractions. Seems like a good idea, but how does a chart with an automatically calculated fraction interval get loaded? I tried setting the intervals to 5 and 1.0 manually in 2.2.0, then loading into m213. No change. :( And updating the chart still resets the scale. Only good news, is that going through with editing the scale manually does clear the log jam, and automatic refresh/recalculation returns to normal afterward. So something saved in the file needs to be "processed" or fixed automatically upon loading.
A further correction: Even after manually editing the y-axis scale, and saving it, Upon loading it again, File.Open it Still does Not update, even though recalculation is set with a check mark, and upon forcing a recalculation F9, it Still changes the scale to it's liking. Also, if I set the major interval to 3, and the minor interval to automatic, it is capable of fractions, albeit not displayed.
I can confirm, that with the attached document the replacement image is not updated, when you change a number on sheet1 without forcing update for the chart. I use version m213 on WinXP. It sounds the same as issue 66865. But shouldn't that be fixed already? The second problem cannot be solved, I think. The automatic has changed, therefore you get a dilemma. When importing you can only keep one of the settings "automatic" or the values. If I set the values in OOo2.2 directly without automatic, then the settings are kept.
->Niklas, please check why the chart is not loaded and updated correctly by the calc. Thanks.
This affects charts that are anchored to the sheet instead of a cell. Fixed on CWS "chart07". Changed: XMLTableShapeImportHelper.cxx 1.27.24.1 XMLTableShapeResizer.cxx 1.28.24.1
Reassigning to QA for verification.
seen ok in cws -> verified
verified fixed in m230, chart is updating, closing.