Issue 69647 - Reverse plot axis direction
Summary: Reverse plot axis direction
Status: CLOSED DUPLICATE of issue 24614
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0.4
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: bjoern.milcke
QA Contact: issues@sc
Depends on:
Reported: 2006-09-18 16:22 UTC by sjors
Modified: 2013-08-07 15:14 UTC (History)
2 users (show)

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

Excel file with scatter-plots with reversed y-axis. See both charts in tab 'Plots'. (72.50 KB, application/
2006-09-19 16:18 UTC, sjors
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description sjors 2006-09-18 16:22:09 UTC
I am not sure if this is the same as If so, sorry.

Excel is able to reverse an axis of a plot (scatter & line). E.g., it can make
the Y-Axis have negative values on top and positive values below. 

If I import such a graph from Excel, the axis are turned upside-up again (with
no warning or error message). 

Converting the resulting openoffice file back to Excel, leaves the figure
upside-up. However, I only tried the latter with an older version of openoffice.
Comment 1 frank 2006-09-19 13:12:24 UTC

please attach a document showing your problem. Without it I can't decide if it's
a double or a new found defect.

Comment 2 sjors 2006-09-19 16:18:58 UTC
Created attachment 39245 [details]
Excel file with scatter-plots with reversed y-axis. See both charts in tab 'Plots'.
Comment 3 sjors 2006-09-19 16:20:45 UTC
I just uploaded an example Excel file.Tab 'Plots' : both plots

In the first graph, in Excel 2000 the vertical axis has -1.500 on top and 1.000
below. Openoffice Calc puts 1.000 on top and -1.500 below. Same story for the
second graph.
Comment 4 sjors 2006-09-25 13:55:39 UTC
I just upgraded to OOo 2.0.4 and I still have the same problem. Also there are
no longer any numbers on the axes, but that might be a different issue.
Comment 5 frank 2006-09-25 14:33:25 UTC
Hi Björn,

new Chart fixes the Y-Axis scaling problem but the second chart has the wrong
labels. Please have a look at this one.

Comment 6 bjoern.milcke 2007-01-12 17:03:24 UTC
Not fixed yet in the new chart. This is duplicate to Issue 24614.

*** This issue has been marked as a duplicate of 24614 ***
Comment 7 bjoern.milcke 2007-01-12 17:03:50 UTC
Closing as duplicate