Issue 122973

Summary:

Chart axis and data labels number format does not updated automatically to changed source format

Product:

Calc

Reporter:

bsimzer

Component:

formatting

Assignee:

AOO issues mailing list <issues>

Status:

CLOSED DUPLICATE

QA Contact:

Severity:

Minor

Priority:

CC:

elish, issues, rainerbielefeld_ooo_qa

Version:

3.4.0

Target Milestone:

---

Hardware:

OS:

Windows 7

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
graph with wrong dates	none
screenshot of Calc	none

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

@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 ***