Issue 51213 - Formatting axes: dates under "scale" reset to number-format when user-defined date format is created under "numbers"
Summary: Formatting axes: dates under "scale" reset to number-format when user-defined...
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
Depends on:
Reported: 2005-06-25 20:26 UTC by suleika
Modified: 2013-02-24 21:22 UTC (History)
2 users (show)

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

example (12.32 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-07-18 18:53 UTC, IngridvdM
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description suleika 2005-06-25 20:26:02 UTC
Using an x-y chart created from two columns; date and bodyweight
Date in spreadsheet is in user-defined format (YYYY-MM-DD-NN)

Left and right-click chart and select "edit"

Format|Axis|X Axis
Tab: "Scale" - date shows in date format
Tab: "Numbers"
Start selecting a user-defined date format MMM-DD
Left-hand column highlight jumps to "user-defined"
Finish entering user-defined date format
"OK" to save setting

Format|Axis|X Axis
Tab: "Numbers"
Left-hand column now has "date" hightlighted, rather than "user-defined" but
"user-defined" is written under the selection panel in which MMM-DD has been entered
Tab: "Scale" - date now shows in number format rather than in date format
Comment 1 frank 2005-06-25 21:17:09 UTC
Wrong component, changed to Chart and re-assigned
Comment 2 kla 2005-07-14 13:03:56 UTC

*** This issue has been marked as a duplicate of 28503 ***
Comment 3 kla 2005-07-14 13:04:24 UTC
closed as duplicate
Comment 4 IngridvdM 2005-07-22 13:06:10 UTC
Sorry, this issue is not a duplicate of  Issue 28503.
But the wrong use of numberformats for the display of values in the scale tab
page is fixed in the coming version of (see for exmpla the
SnapShot build 1.9.m118 at ).
The hightlighting of "date" in the categories list on the number tabpage is
intended if a userdefined format is selected that fits the criteria to be a
'date' format.
Comment 5 IngridvdM 2006-10-31 16:52:38 UTC
Comment 6 IngridvdM 2006-10-31 16:53:35 UTC
I take over to check later
Comment 7 gercokees 2007-07-18 13:15:30 UTC
We have a new chart. Is this still an issue? Else it is better to close...
Comment 8 IngridvdM 2007-07-18 18:52:00 UTC
Hm, yes, with a user defined date format this issue still exist (SRC680m219)
Comment 9 IngridvdM 2007-07-18 18:53:39 UTC
Created attachment 46897 [details]
Comment 10 IngridvdM 2007-09-11 15:42:56 UTC
changing target
Comment 11 IngridvdM 2007-12-04 15:37:12 UTC
This seems to be fixed already in the current master. A data format now is
offered for input. I tested src680.m238. I assume that it was fixed along with
issue 56524 and issue 81259 in CWS chart11 integrated into SRC680.m226.
Comment 12 IngridvdM 2007-12-04 15:38:01 UTC
->Thomas, please verify in current master.
Comment 13 kla 2007-12-10 13:47:56 UTC
Seen ok in current master
Comment 14 kla 2007-12-10 13:48:33 UTC