Issue 89198 - Date values on X axis in all charts
Summary: Date values on X axis in all charts
Status: CLOSED DUPLICATE of issue 85310
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: IngridvdM
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-05-08 19:40 UTC by jbierling
Modified: 2013-02-24 21:19 UTC (History)
1 user (show)

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

Attachments
Test document. (20.50 KB, text/plain)
2008-05-23 15:43 UTC, jbierling 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description jbierling 2008-05-08 19:40:58 UTC 
Chart shows axis dates in reverse order from Excel 2007.  In Calc's case,
turning on the "Reverse direction" option for the axis fixes the issue, but then
the dates are reversed in Excel.  In Excel, turning on the "Dates in reverse
order" again flips the chart axis.
Comment 1 kla 2008-05-13 14:11:30 UTC 
@DR: pls have a look
Comment 2 daniel.rentz 2008-05-23 12:44:29 UTC 
Could you attach a test document please?
Comment 3 jbierling 2008-05-23 15:43:10 UTC 
Created attachment 53889 [details]
Test document.
Comment 4 jbierling 2008-05-23 15:45:48 UTC 
The problem occurs when the dates are in descending (top to bottom) order. 
Excel still shows the dates from left to right while Chart will show the dates
from right to left.

If the dates are in ascending order, both Excel and Chart will show identical
charts.
Comment 5 daniel.rentz 2008-05-26 10:08:18 UTC 
Excel supports a special type of X axis in normal (bar/line/area etc) charts, if
the source data of the labels consists of dates only. This axis type orders the
dates internally in ascending order, similar to the X axis in XY (scatter)
charts. OOo chart does not support this type of axis, so it handles the axis
labels in order of the source data like simple text labels. Therefore you see
the dates in descending order.

Workaround: create an XY chart instead of a line chart.

DR->BM: do you have an issue for this missing feature?
Comment 6 IngridvdM 2008-07-03 11:40:17 UTC 
change owner
Comment 7 IngridvdM 2008-08-27 12:35:21 UTC 
This issue is duplicate to issue 85310.

*** This issue has been marked as a duplicate of 85310 ***
Comment 8 Mechtilde 2008-11-05 21:21:45 UTC 
close the duplicate