Issue 82905 - Error margins from invalid data gives wild results
Summary: Error margins from invalid data gives wild results
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-10-24 01:26 UTC by shelagh
Modified: 2013-02-24 21:21 UTC (History)
2 users (show)

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

Attachments
Using error margin with extra row of data (53.60 KB, image/png)
2007-10-24 01:33 UTC, shelagh 		no flags Details
Incidental strange effect when curser is moved. (53.22 KB, image/png)
2007-10-24 01:36 UTC, shelagh 		no flags Details
Error margin option with the right data. (35.92 KB, image/png)
2007-10-24 01:37 UTC, shelagh 		no flags Details
Using the standard deviation error bar option with extra data. (31.34 KB, image/png)
2007-10-24 01:38 UTC, shelagh 		no flags Details
example doc (15.84 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-10-24 08:57 UTC, IngridvdM 		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 shelagh 2007-10-24 01:26:22 UTC 
Using OOo 2.3 as shipped with Ubunut gutsy.


Steps to take. Make a small sample of data with x-labels and y-labels in talble.
Include and extra row of data such as a title row for the table. Highlight the
table including the title row. Start the chart wizard and make a simple column
chart. 

When it's finished and you are out of the chart wizard.  Highlight the chart so
that the insert menu shows the statistics menu item. Open that and choose the
error margin radio button. Now finish the chart and see the lines. 

Now I realise that the initial fault is with the data, obviously the data
includes too many lines, the title row should be left out. But if I use any of
the other error bar types this problem does not show up. So in my total
ignorance I suggest that some error trapping mechanism isn't working in this one
case. 

Shelagh
Comment 1 shelagh 2007-10-24 01:33:53 UTC 
Created attachment 49098 [details]
Using error margin with extra row of data
Comment 2 shelagh 2007-10-24 01:36:16 UTC 
Created attachment 49099 [details]
Incidental strange effect when curser is moved.
Comment 3 shelagh 2007-10-24 01:37:15 UTC 
Created attachment 49100 [details]
Error margin option with the right data.
Comment 4 shelagh 2007-10-24 01:38:24 UTC 
Created attachment 49101 [details]
Using the standard deviation error bar option with extra data.
Comment 5 frank 2007-10-24 08:46:08 UTC 
wrong component, changed to Chart and re-assigned
Comment 6 IngridvdM 2007-10-24 08:56:45 UTC 
Confirmed. Looks like there is missing a check for valid data. Thanks for the
report.
Comment 7 IngridvdM 2007-10-24 08:57:41 UTC 
Created attachment 49106 [details]
example doc
Comment 8 IngridvdM 2007-11-15 19:06:32 UTC 
Fixed in CWS chart15.
Comment 9 IngridvdM 2007-12-13 16:43:39 UTC 
->Thomas, please verify in CWS chart15.
Load the attached bug doc and double click on the charts to see the corrected view.
(Just to avoid confusion: To create a new persistent replacement image you need
to modify the chart. Otherwise the old replacement image is shown again when
leaving the edit mode.)
Comment 10 IngridvdM 2007-12-13 16:47:25 UTC 
added me to CC
Comment 11 kla 2007-12-28 10:10:55 UTC 
Verified (only the part Error margins from invalid data gives wild results)
As described :
"To create a new persistent replacement image you need
to modify the chart. Otherwise the old replacement image is shown again when
leaving the edit mode." is only for the win Version given, the new replacement
image are shown without modify in Linux Version.
A separate issue will deal with it.
Comment 12 kla 2008-06-13 13:48:40 UTC 
seen ok in current master -> closed