Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||With data series in rows, chart wizard gets data references wrong|
|Status:||CLOSED FIXED||QA Contact:||issues@graphics <issues>|
|Version:||3.3.0 or older (OOo)||Keywords:||ms_interoperability, usability|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
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 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
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