Issue 127813

Summary: chart wizard does not assign data ranges correctly for xy chart
Product: Calc Reporter: Jeff Orrok <jeff>
Component: uiAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P5 (lowest) CC: oooforum
Version: 4.1.2   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
data obtained from https://catchchallenger.first-world.info/wiki/Quick_Benchmark:_Gzip_vs_Bzip2_vs_LZMA_vs_XZ_vs_LZ4_vs_LZO
none
ods with manually corrected x & y values for the chart
none
ods with manually corrected chart and the bad chart the wizard creates
none
screenshot showing manually corrected chart on top, bad wizard chart on bottom none

Description Jeff Orrok 2018-07-10 23:08:53 UTC
Created attachment 86449 [details]
data obtained from https://catchchallenger.first-world.info/wiki/Quick_Benchmark:_Gzip_vs_Bzip2_vs_LZMA_vs_XZ_vs_LZ4_vs_LZO

using the attached data, I clicked in an empty cell in column J and selected Insert > Chart...
Then I clicked on XY (Scatter) and clicked Next>>
Then I changed the data range to be $Sheet1.$G$1:$I$46, selected Data series in rows, and checked both First row as label and First column as label and clicked Next>>

At this point I'm at the Data Series step of the wizard and there are 45 Data series, and for each one, there is nothing for the X-Values, so of course none of the symbols are plotted where they belong.

For example when you select the first Data series of gzip_1, you see the following:
Name - $Sheet1.$G$2 (this is correct)
X-Values - empty
Y-Values - $Sheet1.$H$2:$I$2

I expected to see:
X-Values - $Sheet1.$H$2
Y-Values - $Sheet1.$I$2
Comment 1 oooforum (fr) 2018-07-11 08:20:22 UTC
Save our time, please attach directly:
- an ODS document with these datas
- two screenshots with returned/expected result
Comment 2 Jeff Orrok 2018-07-14 18:54:41 UTC
Created attachment 86455 [details]
ods with manually corrected x & y values for the chart
Comment 3 Jeff Orrok 2018-07-14 19:00:43 UTC
Created attachment 86456 [details]
ods with manually corrected chart and the bad chart the wizard creates
Comment 4 Jeff Orrok 2018-07-14 19:12:13 UTC
Created attachment 86457 [details]
screenshot showing manually corrected chart on top, bad wizard chart on bottom