Issue 122973 - Chart axis and data labels number format does not updated automatically to changed source format
Summary: Chart axis and data labels number format does not updated automatically to ch...
Status: CLOSED DUPLICATE of issue 59793
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 3.4.0
Hardware: PC Windows 7
: P3 Minor (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2013-08-07 18:56 UTC by bsimzer
Modified: 2017-05-20 09:53 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

graph with wrong dates (13.49 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-08-07 19:06 UTC, Edwin Sharp
no flags Details
screenshot of Calc (202.11 KB, image/jpeg)
2013-08-07 19:08 UTC, Edwin Sharp
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description bsimzer 2013-08-07 18:56:31 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.
Comment 1 Edwin Sharp 2013-08-07 19:06:33 UTC
Created attachment 81268 [details]
graph with wrong dates
Comment 2 Edwin Sharp 2013-08-07 19:08:00 UTC
Created attachment 81269 [details]
screenshot of Calc
Comment 3 Edwin Sharp 2013-08-07 19:08:49 UTC
Rev. 1503704 Debian.
Comment 4 Rainer Bielefeld 2013-08-07 20:42:36 UTC
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, ...)
Comment 5 Edwin Sharp 2013-08-08 07:28:23 UTC
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?
Comment 6 Rainer Bielefeld 2013-08-08 10:33:27 UTC
CONFIRMED means, that a developer should take for fixing, please see 
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 ***