Issue 90704

Summary: With data series in rows, chart wizard gets data references wrong
Product: General Reporter: drc <drc>
Component: chartAssignee: kla <thomas.klarhoefer>
Status: CLOSED FIXED QA Contact: issues@graphics <issues>
Severity: Trivial    
Priority: P3 CC: IngridvdM, issues
Version: 3.3.0 or older (OOo)Keywords: ms_interoperability, usability
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Trivial example none

Description drc 2008-06-13 17:01:34 UTC 
See attached spreadsheet.

The column based data presents good default charts whatever chart type is chosen.

The row based data 'fails' at the pie chart and others.

Manually fixing the data ranges works, but is a pain, and will put off newbies
evaluating OOo

If possible, when the wizard detects and suggests  (first row as label) *and*
not(first column as label), could it be made to default to 'data series in rows'

As the expensive Marketing consultants say, "Every Little Helps", and hopefully
not too difficult.

Thanks

Chris
Comment 1 drc 2008-06-13 17:03:24 UTC 
Created attachment 54462 [details]
Trivial example
Comment 2 drc 2008-06-13 19:48:10 UTC 
Oops - I meant to downgrade the priority.  Now I can't change it.  Sorry.
Comment 3 oc 2008-06-20 07:05:55 UTC 
adjusting component
Comment 4 kla 2008-06-20 14:28:23 UTC 
As i can see the issue is part of cws chart29 so i set the target OOo3.0 and
change the owner to iha.
Comment 5 IngridvdM 2008-07-01 10:28:11 UTC 
*** Issue 91069 has been marked as a duplicate of this issue. ***
Comment 6 IngridvdM 2008-07-09 15:56:25 UTC 
I agree that this is a major usability issue. I fixed as follows for Charts in Calc:
If only one row with values is selected the ranges are taken from rows,
otherwise from columns. I don't changed anything in Writer. Having a single row
in Writer selected created a Chart from rows already. For further changes open
separate issues please.
Comment 7 IngridvdM 2008-07-10 09:04:09 UTC 
@Thomas, please verify in CWS chart29.
Comment 8 IngridvdM 2008-07-10 12:28:41 UTC 
One small error: in case of exactly two rows of data and one row as label the
default switches to rows what was not intended here. Thanks Thomas for finding
this with the test tool.
Comment 9 IngridvdM 2008-07-10 15:38:04 UTC 
Ok the above small error is fixed now also.
@Thomas, please verify in CWS chart29.
Comment 10 kla 2008-07-16 08:36:44 UTC 
Seen ok in cws chart29 -> verified
Comment 11 kla 2008-08-27 10:59:44 UTC 
Seen ok in current master -> closed