Apache OpenOffice (AOO) Bugzilla – Issue 15298
Stock charts display wrong if Y-axis scale maximum is less than max data point
Last modified: 2013-02-24 21:20:49 UTC
Hi, when using chart type Stock Chart 3 (and possibly other types), the display breaks when the Y axis is scaled to be less than (say) the high value. It looks like some sort of wrapping around is going on, as the high ends up very low. I'll attach an example file. Incidentally, all of the chart bugs are getting assigned to Falco, but they're not getting fixed. I assume he's working on other stuff. But accurate and usable charts and graphs are really important for those of us who us OOo for scientific presentations. I would urge Sun to put some resources into this area, and/or for someone in the open-source community to take it up as a cause. If I had more time, I might volunteer, but I don't have the time to do much more than QA right now... Thanks, -Harlan
Created attachment 6665 [details] file that illustrates broken scaling
Hi Bettina, one for you.
This is a bug, not an enhancement request. The current behavior is wrong.
Hi harlan879, I tried your example "ooo.stock.scaling.bug.sxc" with my I checked with 1.1.1 WIN XP: [645m35(Build8762)] and everything seemd to be correct. But I must admit, I am no great chart expert, so can you please add a screenshot with a view of the charts on you PC? I will compare it with my results. If you find unexpected behaviour also on my screenshot, please explain that in a further comment! Rainer
Created attachment 15296 [details] so it looks on my PC
Ah, oops, I had slightly misunderstood how the stock charts work, with the 2nd axis. To see the bug, you have to manually scale both Y axes to be the same, and have a data point out of range. I'll attach a new file that shows the bug (which still shows up in my copy of 1.1.1 on Win XP). Your screen shot looks exactly like mine. Note that I'm using the stock chart as a kludgy replacement for working bar charts with standard deviations. (Currently, they're disfunctional.) My understanding is that working error bars (which are critical for acceptance by the scientific community) are expected to be working in OOo 2.0. That's not this bug, though. :)
Created attachment 15297 [details] better illustration of the bug
I believe now I understand. I checked with 1.1.1 WIN XP: [645m35(Build8762)] and also 2.0 English version WIN XP [680m55(Build8735)]. Steps tor reproduce the problem: 0. open "ooo.stock.scaling.bug2.sxc" Chart "Manually scaled both axes to 300" shows the correct view Chart "Scaled to 200 – hi wraps around!" shows an incorrect view 1. doubleclick on chart "Scaled to 200 – hi wraps around!" 2. doubleclick on the right Y-axis 3. change 'Scale - maximum' from "200" to "300" 4. <OK> now you see the correct view with a black line from "100" to "250" ("Row 2") 5. Menu 'Edit - Undo' expected: the black line should go fom 100 to 200 (on the right y-axis), rest of the line (200 ... 250) should be cut away actual: now the line goes down from "100" to "0" (on the right y-axis) That's wrong. Thes should be tested for the new chart design! Rainer
.
Hm, it looks strange. Ingrid, pls have a look.
I will check this in new chart.
-> Björn: As the new chart will not make it for the next release, please have a look wether you can fix this in the old implementation. Thanks.
according to http://www.openoffice.org/servlets/ReadMsg?list=releases&msgNo=7690 this issue will be set to OOoLater
iha->bm: I'll take this issue back than.
accepted
With the complete re-implemenation of the chart module starting with SRC680m213 this bug has changed. Now the min max lines are drawn correctly, but the close value is displayed wrongly when the value is out of the scale range.
Fixed in CWS chart15
->Thomas, please verify in CWS chart15.
Seen ok in cws chart15 -> verified
Verified fixed in OOH680_m5, closing