Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Allow angle settings that lead to vertical lines|
|Product:||General||Reporter:||Regina Henschel <rb.henschel>|
|Component:||chart||Assignee:||AOO issues mailing list <issues>|
|Status:||REOPENED ---||QA Contact:|
|Version:||3.3.0 or older (OOo)|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
Description Regina Henschel 2006-12-29 15:39:54 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.
Comment 1 kla 2007-01-02 11:27:17 UTC
@IHA: Maybe a good idea.
Comment 2 IngridvdM 2007-01-04 17:12:09 UTC
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.
Comment 3 IngridvdM 2007-09-12 09:10:44 UTC
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?
Comment 4 IngridvdM 2007-09-21 12:41:19 UTC
I set this to duplicate of Issue 67754 now. *** This issue has been marked as a duplicate of 67754 ***
Comment 5 IngridvdM 2007-09-21 12:42:13 UTC
closed as duplicate
Comment 6 Regina Henschel 2007-12-21 00:28:32 UTC
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.
Comment 7 Regina Henschel 2007-12-21 00:30:16 UTC
Created attachment 50512 [details] Excel document with 3D chart
Comment 8 Regina Henschel 2007-12-21 00:32:04 UTC
Created attachment 50513 [details] OOo document to try to get same chart as in Excel
Comment 9 Regina Henschel 2010-01-03 17:31:28 UTC
Created attachment 66957 [details] Basic Library with Macro UprightChart
Comment 10 Regina Henschel 2010-01-03 17:32:12 UTC
Created attachment 66958 [details] Document with 3D Column Chart
Comment 11 Regina Henschel 2010-01-03 17:45:56 UTC
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.