Apache OpenOffice (AOO) Bugzilla – Issue 20293
Excel Chart Import: auto Y axis scaling with manual 'axis at' value
Last modified: 2013-08-07 15:12:27 UTC
I have a document that was created in Excel 97 and it has a graph in it. When opened in OOo, the graph scale is different. I will include a copy of the document with this report.
Created attachment 9775 [details] The document in question.
I can Reproduce the problem on OpenOffice 1.1 RC5(default Install, US), Win XP Pro Sp1. (And MS Office XP Sp2). It is real problem Weight field which is originally start from 91 to 102 (1 increment) is diplayed wrongly in OOo as 10 to 110, with 10 increment.
Hi Bjoern, one for you. The minimum setting was not taken into account I think. Frank
This looks like an import problem to me. The origin is set to 0 and the minimum is auto, therefore the minimum is also set to 0. The origin should be auto instead.
According to the roadmap of OpenOffice.org 1.1 (http://tools.openoffice.org/releases/Openoffice_org_1_x.html) this issue has been scheduled for 1.1.2.
2 problems: 1) Excel filter: Automatic origin flag imported wrong 2) Chart: Different behaviour with manual origin and automatic axis limits (Excel limits origin to visible axis range)
Due to reimplementation of the chart module in OOo2.0 this task is retargeted to OOo2.0
according to http://www.openoffice.org/servlets/ReadMsg?list=releases&msgNo=7690 this issue will be set to OOoLater
DR->BM: After looking into the attached document again, I see that the import filter works correctly. These are the settings of the Y axis in the Excel document (sheets "De Weldon Warren", "Mc Connell Ken", "Midgely Brian"): Min = auto Max = auto Cross = 0.0 Excel detects e.g. Min=91, Max=102 on sheet "Midgely Brian". Excel does not extend this range to a manual crossing point. Axis will be drawn at the nearest limit instead (minimum 91 in this case).
iha->bm: I'll take this issue.
accepted
checking again in SRC680m222 the scaling in the chart differs still very much. I think the automatism in excl is wrong in case of having a not automatic 'axis at' value while having auto min and max. The min and max should then include the manual 'axis at' setting. So I won't change the chart automatic for this. ->Daniel, please consider to just set an automatic 'Axis at' during import in that cases when min and max are set to auto too. But I am not sure whether other cases are then more wrong than now. Maybe this wrong behaviour of excl is charttype specific?
*** Issue 81676 has been marked as a duplicate of this issue. ***
Was still reproducible with OOo 2.0.2, Y-Axis range started with "0" instead of 90 (or so). Still the same with OOo 3.1.1 No longer eproducible with "AOO 4.0.0-Dev – German UI / locale [AOO400m2(Build:9701) - AOO400m2(Build:9701) - Rev. 1497734 Rev.1496828 2013-06-28]" on WIN7 Home Premium (64bit)", Common 4.0-dev User Profile. Already fixed in AOO 3.4.0, there Y-asis minimum is 90