Issue 69647

Summary:

Reverse plot axis direction

Product:

Calc

Reporter:

sjors <provoost>

Component:

formatting

Assignee:

bjoern.milcke

Status:

CLOSED DUPLICATE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

ht990332, issues

Version:

OOo 2.0.4

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
Excel file with scatter-plots with reversed y-axis. See both charts in tab 'Plots'.	none

Description sjors 2006-09-18 16:22:09 UTC

I am not sure if this is the same as
http://www.openoffice.org/issues/show_bug.cgi?id=68552. 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

Hi,

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

Frank

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.

Frank

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