Apache OpenOffice (AOO) Bugzilla – Issue 72995
Allow angle settings that lead to vertical lines
Last modified: 2013-09-25 20:41:26 UTC
In Excel the rotation always acts in that way, that the vertical lines of the column boxes remain vertical, so that the lines have no stairs. If you will achieve such vertical lines with the new chart it is difficult. If x- and y-angles are given, you need decimal z-angles, which are not possible. An alternative could be, to provide a button "align vertical" and use such angles internally. You will need it too, for correct importing of Excel charts.
@IHA: Maybe a good idea.
Thanks Regina. I see the problem with the vertical lines. But maybe we should choose another solution and change the angle interpretation to what Excel does. I changed the summary to address the root problem.
Isn't this issue solved now with the integration of the right-angled axes feature - see issue 67754 . Or is there any need for further changes in this direction?
I set this to duplicate of Issue 67754 now. *** This issue has been marked as a duplicate of 67754 ***
closed as duplicate
No it is not solved with right angles. I'll attach an Excel document with a chart and a Calc document with the same data and a picture of the Excel chart. (Importing the Excel document doesn't help, because import of 3D charts is still broken.) Now try to make an OOo chart, that looks like Excel's chart. You cannot get it by entering the rotation value, although you can calculate them (see issue 72994), because you cannot enter decimal values. Try to get it by dragging it with the mouse in rotation mode. You will not be able to get vertical lines without steps, at least I couldn't it. Right angle is no option, because then the x-axis is horizontal.
Created attachment 50512 [details] Excel document with 3D chart
Created attachment 50513 [details] OOo document to try to get same chart as in Excel
Created attachment 66957 [details] Basic Library with Macro UprightChart
Created attachment 66958 [details] Document with 3D Column Chart
I have uploaded a Basic Library containing the macro UpRightChart. Take a Column chart in 3D view. Use the angles X=20°, y=30°, Z=10° for example, uncheck Perspective and uncheck "Right Angles". Try to get nice vertical lines for the boxes by entering a Z angle value or by rotating the diagram with the mouse. Now import the library, select the chart and execute the macro UpRightChart. You will notice the difference immediately. The macro is only for 3D Column charts and will not work correct for other chart types. I do not try to make a solution, which can be put directly into the code. But I want to show you, what this issue is about.