Description: Example: If you have a column of x values that respond to 2 half columns of y values, then the graph cannot be represented at all. Eg; (A, B, C) 1, 10, - 2, 13, - 4, 25, - 1.3, -, 17 2.8, -, 27 5.7, -, 45 Column A should be x values, and when Row 1 is used, then 25 should be plotted at an X value of 1, Row 3 should have 25 plotted at an X value of 4 (and *NOT* 3). Row's 4 through 6 should be a separate line/series, Row 4 should plot 25 at an X value of 1.3 on the X axis (and *NOT* 1 OR 4) If you create this type of graph within Google Sheets, it is created correctly, but if you download the Ods or Xlsx file, then Calc will wrongly interpret the graph. Please try downloading and opening: https://docs.google.com/spreadsheets/d/1UlBWKmaz0YsErMJgwvp_BrzfmTr_Fvzk5OuJgaf4L4U/edit#gid=0 Steps to Reproduce: 1. Create three columns of Values, Column A should be the X axis, Column B should be plot 1 and Column C should be plot 2, X axis values in Column A should be non-sequential 2. Select the range and create Chart 3. Observe issue 4. Download Google Sheet as ods or xlsx from https://docs.google.com/spreadsheets/d/1UlBWKmaz0YsErMJgwvp_BrzfmTr_Fvzk5OuJgaf4L4U/edit#gid=0 5. Open in Calc 6. Observe issue Actual Results: Chart does not plot data at the correct X axis values Expected Results: Chart should plot data at the corresponding X axis values Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Version: 6.4.0.3 (x64) Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8 CPU threads: 8; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; Locale: en-AU (en_AU); UI-Language: en-US Calc: threaded
Created attachment 157560 [details] Example Chart Compared to how graph should be displayed at: https://docs.google.com/spreadsheets/d/1UlBWKmaz0YsErMJgwvp_BrzfmTr_Fvzk5OuJgaf4L4U/edit#gid=0
>Column A should be x values, and when Row 1 is used, then 25 should be plotted at an X value of 1, Row 3 should have 25 plotted at an X value of 4 (and *NOT* 3). Correction Column A should be x values, and when Row 1 is used, then 10 should be plotted at an X value of 1, Row 3 should have 25 plotted at an X value of 4 (and *NOT* 3).
>Row's 4 through 6 should be a separate line/series, Row 4 should plot 25 at an X value of 1.3 on the X axis (and *NOT* 1 OR 4) One more correction Row's 4 through 6 should be a separate line/series, Row 4 should plot 17 at an X value of 1.3 on the X axis (and *NOT* 1 OR 4)
Hi Dan, You can get an expected chart changing chart type from line to XY (scatter). Would you try it?
Dear Dan, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear Dan, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp