Apache OpenOffice (AOO) Bugzilla – Issue 127813
chart wizard does not assign data ranges correctly for xy chart
Last modified: 2018-07-14 19:12:13 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
Save our time, please attach directly: - an ODS document with these datas - two screenshots with returned/expected result
Created attachment 86455 [details] ods with manually corrected x & y values for the chart
Created attachment 86456 [details] ods with manually corrected chart and the bad chart the wizard creates
Created attachment 86457 [details] screenshot showing manually corrected chart on top, bad wizard chart on bottom