Apache OpenOffice (AOO) Bugzilla – Issue 122973
Chart axis and data labels number format does not updated automatically to changed source format
Last modified: 2017-05-20 09:53:05 UTC
When you have a chart, and you already set the axis (x axis in my case) to a date column, and then you change the date formatting on that column (dd/mm/yyyy vs Month dd yy, for example), that new formatting is not applied to the chart. To have the chart update, you have to re-add the axis column. This could be design intent, but I think this is a bug.
Created attachment 81268 [details] graph with wrong dates
Created attachment 81269 [details] screenshot of Calc
Rev. 1503704 Debian.
Reproducible with any WIN (A)OO Version I tested Additional Info: ----------------- a) I never saw that working different back until 2.0.3 (more early not tested), so Format -> 3.4.0 (May be we should have a pre-3.4.0) b) I really really doubt that this never has been reported. Quick check shows "Bug 59793 - "Source format" change does not lead to auto update of charts axis, make it so", may be there are more c) The problem has nothing to do with Date, any number formatting of Axis will not be updated before scaling change, Chart Edit Mode or Recalculation (<f9>) d) Problem is not limited to Axis (as per original report), also data labels, may be all numbers in Chart are affected. d) I do not think that this one es a MAJOR bug, because there is an easy workaround. f) Competitors: Softmaker FreOffice updates immediately Calligra: Crashed @bsimzer, Edwin: Can you please gain some more info concerning related bugs and related effects? Then we can decide what to do (what one is what one's DUP, ...)
Please observe attachment 81269 [details]. While trying to reproduce description by bsimzer encountered fatal error in graph as abscissa differs from source data! If "Reproducible with any WIN (A)OO Version I tested" why unconfirmed this bug?
@Edwin: CONFIRMED means, that a developer should take for fixing, please see <http://wiki.openoffice.org/wiki/QA/HowToFileIssue#Principles>, <http://wiki.openoffice.org/wiki/BUGZILLA/FAQ> and other related information. So for this one, what obviously is a DUP of Bug 59793 (I did no find other possible DUPs, but I did nor search intensively), CONFIRMED is inappropriate. I will add additional relevant info gained here to Bug 59793 in the evening. *** This issue has been marked as a duplicate of issue 59793 ***