Apache OpenOffice (AOO) Bugzilla – Issue 69647
Reverse plot axis direction
Last modified: 2013-08-07 15:14:21 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.
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
Created attachment 39245 [details] Excel file with scatter-plots with reversed y-axis. See both charts in tab 'Plots'.
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.
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.
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
Not fixed yet in the new chart. This is duplicate to Issue 24614. *** This issue has been marked as a duplicate of 24614 ***
Closing as duplicate