Apache OpenOffice (AOO) Bugzilla – Issue 62538
xy diagram can only spline in y direction
Last modified: 2013-02-24 21:20:50 UTC
Create a diagram over pairs of unsorted numbers. (e.g. you want to create a circle diagram with sin(x) and cos(x)) When you create a xy diagram with straight lines it works, but when you try to create a splined diagram you get a warning message saying "numbers must be sorted". This is because the spline function works only in one dimension, not in x and y. If you ignore the warning and continue, the result is something unexpected. Excel can do that correctly, and on some cases it makes sense.
Wrong Component, changed to Chart. Possibly a double.
duplicate *** This issue has been marked as a duplicate of 46521 ***
closed as duplicate
I disagree, this is not a duplicate issue, the other issue is only about the sorting dialog. If you ignore this dialog a spline xy diagram does not work as expected. If i do a splined xy diagram i expect that the spline works in both directions, but it does not. No matter if you sort the data or not, the spline is effective only in y direction. Example: if you spline xy data: 0 ; 1 1 ; 0 0 ; -1 -1 ; 0 is unsorted, and one would expect a spline to draw a circle. In MS Excel you see a circle, in OO you see something different. What OO does here is not incorrect, but it covers only a part of what the user wants to do. Optimum would be if the dialog for the xy diagram type differentiates "Y spline" , "XY spline" and maybe "X spline" and process accordingly. In my eyes this is more correct because then you do have the choice.
The number of the duplicate was wrong. I think this is a duplicate of Issue 13699. *** This issue has been marked as a duplicate of 13699 ***