Issue 127813 - chart wizard does not assign data ranges correctly for xy chart
Summary: chart wizard does not assign data ranges correctly for xy chart
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 4.1.2
Hardware: All All
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-07-10 23:08 UTC by Jeff Orrok
Modified: 2018-07-14 19:12 UTC (History)
1 user (show)

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


Attachments
data obtained from https://catchchallenger.first-world.info/wiki/Quick_Benchmark:_Gzip_vs_Bzip2_vs_LZMA_vs_XZ_vs_LZ4_vs_LZO (2.00 KB, application/vnd.ms-excel)
2018-07-10 23:08 UTC, Jeff Orrok
no flags Details
ods with manually corrected x & y values for the chart (36.03 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-07-14 18:54 UTC, Jeff Orrok
no flags Details
ods with manually corrected chart and the bad chart the wizard creates (55.44 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-07-14 19:00 UTC, Jeff Orrok
no flags Details
screenshot showing manually corrected chart on top, bad wizard chart on bottom (185.40 KB, image/png)
2018-07-14 19:12 UTC, Jeff Orrok
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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