Apache OpenOffice (AOO) Bugzilla – Issue 85625
Flexible positioning of axes and axis labels
Last modified: 2013-02-24 21:19:51 UTC
When we create xy diagrams in OOoCalc, graduations are around a box. In most of their works, teachers and students need graduations to be placed near the axes (Ox) and (Oy) Excel and gnumeric have allready implemented this functionality. In the same file, graduations are near axes when open with excel or gnumeric, and around a box when open with OOoCalc. http://www.forum-openoffice.org/forum/ftopic3975.html&sid=e8f3556a200bad49368d62a5bf8a0007 This is important for the possibility to use OOoCalc in building officials exams documents in France. We find urgent to implement this functionality of graduation near (Ox) and (Oy) axes.
@fred : after being discussed with Eike Rathke, the issue appear to be a chart issue @bm : I'm not sure I have choosen the right component/subcomponent, can you confirm ? thanks :-)
As Physics teacher in the real life, I can only confirm this requirement is really important. The good behaviour could be: write the list of what exactly has to be done to solve the issue : - do we need to wtie specs ? - do we need to attach screenshots (showing concurent office, and what is expected) - (please tell us ) Thanks :-) Issue confirmed
+ me on CC
Taking over. As far as I understood the French forum discussion, this is about having the axis labels directly at the axis, instead of having it only on the edges of the diagram area. ->ericb: It would help to have a screenshot to illustrate the problem. In addition, we would of course like to offer the current placement. Therefore we would need some kind of switch to tell the axis where to place its labels. This requires a specification and an ODF file-format specification. I wouldn't change the behavior (without switch), not only for compatibility, but also because it might look bad if the labels overwrite each other, or data labels, etc. that are at the same place.
it is a real problem in athematic... Yhank you
ericb@bm Thanks for taking over the issue, and sorry for answering lately : I'll ask Fred. Your suggestion about use a switch looks great, and if you need help for build or help for QA, I'm your man. I just don't understand well the ODFfile-format issue: what happens exactly ? Is it problematic because of time issue or because too complicated to add ?
Created attachment 51347 [details] Contains datas plotted in xy diagrams with OOocalc and gnumeric
In this file, you can notice that gnumeric allows user to choose the position of axes, and especially to make them cross in (0;0)
All secondary schools in North of France (Académie de lille) have now at least one classroom, with one computer for each pupil. We have installed OpenOffice (or StarOffice) everywhere. As a computer science teacher, I have met most of the maths teachers using those computers. One main problem using OpenOffice, instead of excel, is having axis labels on the edges of the diagram area. French pupils are not at all used to it. Excel can write axis labels directly on the axis, as French children do on paper work. So this requirement is really important for us, and will favorably influence the choice of OpenOffice Calc in most French schools. Thanks for your help
it is a real problem in mathematic... Thank you
I had a teacher training today (in France, secondary education) about spreadsheets (Calc and Excel) and this limitation appeared to be very annoying to all teachers trained. It seems to be one of the serious reasons to keep on using, eg, Excel. Hope OOo 3 will have this feature. Thanks a lot for your work !
Please consider these two additional aspects in order to meet the usual requirements for use in school: (1) One must be able to assign an arrow style to the axis (similar to the line object in the application´s draw functions. (2) When axis cross at (x=0;y=0) the label "0" must not be displayed twice but onliy once. See this example http://de.wikipedia.org/wiki/Bild:Koordinatensystem.png for a typical coordinate plane used in schools.
Add me to CC.
change owner
change target
I create a specification describing a new page 'Positioning' for the axis dialog: http://specs.openoffice.org/chart/ChartAxisPositioning.odt In addition the scale page will change for this feature: http://specs.openoffice.org/chart/ChartAxisScale.odt I implemented the described behavior in CWS calcchartrtl01. Thus interested people knowing how to build a CWS might have a look already. Feedback is welcome. Loading and saving does not work so far, as the necessary file format changes need to be send to OASIS first and have to be discussed and approved there.
Created issue 94582 for the necessary changes in the documentation. Created issue 94581 for the necessary changes in the automatic testing scripts.
moved fixes to CWS rtlchart02.
*** Issue 55501 has been marked as a duplicate of this issue. ***
The OASIS TC has approved the necessary file format extension: http://wiki.oasis-open.org/office/AxesPosition The issue is fixed in CWS rtlchart02.
Created attachment 58141 [details] example document
@Thomas, please verify in CWS rtlchart02.
Created attachment 58540 [details] Testcasespecification for Axis positioning
Created attachment 58551 [details] Testcasespecification for Axis Scale reference value on secondary Axis
Seen ok in CWS rtlchart02 -> verified
I think is possible a provisional solution, adding two lines, one with 0 on x and another one with 0 on y, mixing with a calculate scale, and showing the values for this lines.
Created attachment 61094 [details] Adding a chart with provisional solution
Seen ok in current master -> closed