Issue 85310 - im-/export date scale
Summary: im-/export date scale
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: daniel.rentz
QA Contact: issues@graphics
URL:
Keywords: ms_interoperability
: 89198 (view as issue list)
Depends on:
Blocks:
 
Reported: 2008-01-16 21:57 UTC by jpryor
Modified: 2017-05-20 11:42 UTC (History)
2 users (show)

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

Attachments
Excel file with mis-rendered chart. (52.00 KB, application/vnd.ms-excel)
2008-01-16 21:58 UTC, jpryor 		no flags Details
How Excel renders it. (9.85 KB, image/png)
2008-01-16 21:58 UTC, jpryor 		no flags Details
Calc Rendering. Notice that the display is horizontally compressed when compared with Excel. (45.26 KB, image/png)
2008-01-16 22:04 UTC, jpryor 		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 jpryor 2008-01-16 21:57:34 UTC 
See the attached .xls file, found at:

http://www.plasticsportal.net/wa/plasticsEU~en_GB/function/conversions:/publish/content/products/price_history.xls

When viewed within Calc, the chart is "compressed" horizontally, such that all
the useful data (lines, X-axis labels, etc.) are drawn across less than half of
the width of the chart.
Comment 1 jpryor 2008-01-16 21:58:35 UTC 
Created attachment 50922 [details]
Excel file with mis-rendered chart.
Comment 2 jpryor 2008-01-16 21:58:59 UTC 
Created attachment 50923 [details]
How Excel renders it.
Comment 3 jpryor 2008-01-16 22:04:02 UTC 
Created attachment 50924 [details]
Calc Rendering.  Notice that the display is horizontally compressed when compared with Excel.
Comment 4 kla 2008-01-17 12:40:13 UTC 
@dr: one for you.
Comment 5 daniel.rentz 2008-04-04 10:55:22 UTC 
The chart in the attached document contains an X axis in date mode instead of
category mode, thus it allows to set manual and automatic minimum/maximum as the
Y axis do. Date axes are not supported in our chart at the current time.

Workarounds
1) Change the source data to *not* include the empty cells below the data. Last
non-empty cell is in row 137, but chart source data links until row 534.
or:
2) Change chart type to scatter chart (XY chart) to be able to change
minimum/maximum at the X axis.

Changing title and issue type.
DR->BM: do you have an issue for date axes in regular charts? 
Excel allows to:
- set min/max (manual and auto)
- set base unit (day/month/year/auto)
- set main/help interval as day/month/year
Comment 6 daniel.rentz 2008-04-04 14:47:15 UTC 
owner
Comment 7 IngridvdM 2008-07-03 11:40:02 UTC 
change owner
Comment 8 IngridvdM 2008-08-27 12:35:21 UTC 
*** Issue 89198 has been marked as a duplicate of this issue. ***
Comment 9 jbierling 2008-11-25 16:17:13 UTC 
Please vote for this issue.

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 10 jbierling 2009-05-07 14:54:55 UTC 
I think the "Issue Type" should be "Defect" not "FEATURE".
Comment 11 IngridvdM 2010-11-24 16:15:24 UTC 
Daniel, please implement the im- and export for date axis after its implemented
with issue 25706 in CWS chart46. Thanks a lot!
Comment 12 daniel.rentz 2010-11-29 12:18:34 UTC 
started
Comment 13 IngridvdM 2010-11-30 10:11:56 UTC 
Daniel, following changes have been made in CWS chart46 to the unpublished
chart2 API:
The css::chart2::AxisType has got a new value 'DATE'.
The  ScaleData has got two new member:
boolean AutoDateAxis and TimeIncrement.
Ignore the new member ShiftedCategoryPosition for the moment, as this is info is
not saved.
Let me know if the API description is not sufficient.
Comment 14 daniel.rentz 2010-12-07 14:28:22 UTC 
fixed in CWS chart46
Comment 15 kla 2010-12-29 10:45:55 UTC 
Seen ok in cws chart 46, example doc looks great and as Date formatted-> issue
verified