Apache OpenOffice (AOO) Bugzilla – Issue 100778
allow fixed positioning of plot-area excluding axis labels
Last modified: 2013-02-24 21:19:09 UTC
Is it possible to plot the zeropoint of the X- and Y axis on specific coordinates in Calc diagrams or is this only possible with the box in which the diagram is placed? Is it an option to divide the diagram box into three boxes. One for the actual diagram, one for the y-axis and one for the x-axis? Then it is possible to position the diagram on the wanted x/y-coordinates. It will also be another mayor improvement in comparison to MSExcel. With this feature added to Calc it will be possible to use Calc for the production of diagrams for the Rotterdam MSR-project. The alignment of the y- axis is crucial for this project. (See http://www.hetmilieuinderegiorotterdam. ... index.html , Hoofdstuk 8 Groen for example (i.e. Chapter '8') and http://www.hetmilieuinderegiorotterdam. ... index.html ) Explanation: When there are 4 diagrams beneath each other in a report, it is essential that the Y-axis are lined-up identically. Otherwise the layout will look messy. When you line-up on the lower left corner of the actual box in which the diagram is placed, it causes a problem when you have a diagram with Y-axis labels consisting of 4 digits, combined with a diagram with Y-axis labels consisting of (for example) 2 digits. The digits on the far left (the first digits of the labels) line-up, but the actual Y-axis next to the 4 digit label will be more to the right then the Y-axis which is labelled with 2 digits. In other words the number of digits determines the placement of the Y-axis. It is possible to manage this problem by trial and error and by the use of reference lines, but it would be better to have a user interface in which you can enter the coordinates of the zero point of the Y-axis. The other items of the diagram should be linked to the Y-axis. See also: http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=16916
Hi Iha, one for you.
I understand the use case and agree that an option would be useful to position the plot area excluding the axis labels. Details have to specified. Also the file format needs to be extended.
Dear Iha, Which details must I specify? When A diagram is ready, we print out the diagram to pdf-file in A4-format, landscape orientation. ArjanjA
@ArjanjA, sorry that I was unclear. It is not necessary that you specify anything. I just wanted to state that this new feature will need some more thoughts about how this could be offered. A switch has somewhere to be offered to choose whether position and size should include the axes or not. Thoughts and comments are welcome here but not necessary. Thanks! :-)
Is it possible to estimate when this item will be ready? Thanks. ArjanjA
ArjanjA, no sorry. There is no schedule for this issue yet. Ingrid.
DR->IHA: reminder: XDiagramPositioning::setDiagramPositionIncludingAxes() does not work correctly yet.
Dear Iha, Still no schedule for this issue? We are very much in need for this feature. Thanks, Arjan
Still no schedule, sorry.
Fixed in CWS chartpositioning. The position and size set within the dialog now does reflect the rectangle of the inner plot area excluding axis titles and excluding axis labels. The same for the rectangle that can be dragged via mouse. Older files are once converted.
@Thomas, please verify in CWS chartpositioning.
Dear Iha, Great! This will be very helpful to us. I understand that it will be available with de 3.3 release. Can you tell me when 3.3 is going to be released? Thanks again, Arjan Aaftink
@arjanja, I am sorry, I don't know that. The issue also needs to pass a testing phase before it can be integrated into the master code line. So integration is not for sure.
Seen fine in cws chartpositioning -> verified
Seen ok in master -> closed