Issue 33849 - Y axis Autoscale works incorrectly if some error indicators are on
Summary: Y axis Autoscale works incorrectly if some error indicators are on
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-09-05 20:47 UTC by Matthias Basler
Modified: 2013-02-24 21:22 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
An example chart with its y axis scaled wrongly (13.88 KB, image/jpeg)
2004-09-05 20:52 UTC, Matthias Basler 		no flags Details
Input data for creating a chart (5.21 KB, application/vnd.sun.xml.calc)
2004-09-24 04:41 UTC, ssarkizo 		no flags Details
XY-Diagram with wrongly scaled y axis because of error bars. (10.00 KB, application/vnd.sun.xml.calc)
2004-10-09 15:06 UTC, Matthias Basler 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Matthias Basler 2004-09-05 20:47:54 UTC 
If in a graphics, the error indicators (type: "constant value") are switched
visible, the diagram is displayed in a strangely compressed way, because the
y-axis autoscale obviously does not work correctly.
Since this error is also affected by the TYPE of error indicator selected
(upper, lower or both), it seems, that OOo Calc overestimates the space needed
for this type of "constant value" error indicators (by a factor of 30 or so).

Currently the workaround is to set the y-axis' min and max values manually.

Found in OOo1.1.2 (German) under WinXP.
Comment 1 Matthias Basler 2004-09-05 20:52:35 UTC 
Created attachment 17551 [details]
An example chart with its y axis scaled wrongly
Comment 2 frank 2004-09-06 08:30:52 UTC 
Wrong component, I've changed it.

Frank
Comment 3 kla 2004-09-06 09:27:29 UTC 
Hi Matthias,
please attach the whole doc.
thanks
Comment 4 ssarkizo 2004-09-24 04:37:53 UTC 
Siranush Sarkizova
09/23/04

I was able to reproduce the bug on OpenOffice 1.1.3. Here us the procedure 
sequence i followed:

1.  Download the attached file data.sxc
2.  Open the file with OpenOffice
3.  Highlight cells A1:A6 and B1:B6
4.  Go to Insert -> Chart (AutoFormat Chart window comes up)
5.  Click Next 
6.  Chose a XY-chart type and click Next again
7.  Click Next
8.  Click Create (the graph that you created should pop up on your spreadsheet)
9.  Go to Insert -> Statistics (Statistics window comes up)
10. Chose Constant Value as a error category
11. Chose Top and Bottom Indicator as error indicator
12. Chose Liner Regression as a regression curve
13. Click OK
Notice that the y axis scale and range does not correspond to the initial data 
values.

I have also plotted a chart with different values and concluded that the bug 
is not dependent on the exact figures. Also in step 11 if another type of 
error indicator is selected (Lower Indicator or Upper Indicator) the 
misbehavior persists as matthiasbasler states.

Configuration:
Windows XP Pro
1.2 GHz AMD Athlon
376 MB
Comment 5 ssarkizo 2004-09-24 04:41:43 UTC 
Created attachment 17892 [details]
Input data for creating a chart
Comment 6 kla 2004-09-24 10:42:54 UTC 
kla->Siranush Sarkizova: thank you for the description
kla->bm: for you
Comment 7 Matthias Basler 2004-10-09 15:04:38 UTC 
Sorry I didn't respond until now - my email was wrong so I got no message (fixed
now).

I cannot send the original data, but have created a sample document that shows
that the diagram's y-axis scale is totally wrong if the fixed-value error bars
are on. One data point is even outside the y-range in this example.

By the way, I reproduced the error in the OOo2.0 codeline (1.9.54) under WinXP.

Please note that I just had to open another issue (35226) also devoted to woring
scaling of diagram axis' and statistical digram options ... just in case the
bugs are connected somehow or fixing one fixes the other too or so.
Comment 8 Matthias Basler 2004-10-09 15:06:20 UTC 
Created attachment 18260 [details]
XY-Diagram with wrongly scaled y axis because of error bars.
Comment 9 bjoern.milcke 2004-10-27 17:19:44 UTC 
will hopefully be fixed with new chart engine.
Comment 10 IngridvdM 2006-01-18 20:40:18 UTC 
IHA->BM: I will take care of this issue.
Comment 11 IngridvdM 2007-07-27 18:38:40 UTC 
This bug was fixed with the complete re-implementation of the chart module
starting with version SRC680m213. A successor issue is 30868. Error bars
currently are not considered at all for auto scaling.
Comment 12 IngridvdM 2007-08-01 13:49:14 UTC 
->Thomas, please verify on master and close.
Comment 13 IngridvdM 2007-08-01 13:49:47 UTC 
add me to CC
Comment 14 kla 2007-08-02 08:32:54 UTC 
verified
Comment 15 kla 2007-08-02 08:33:14 UTC 
seen ok in master -> closed