[Libreoffice-bugs] [Bug 130324] New: Calc does not create or display graph plots correctly

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=130324

            Bug ID: 130324
           Summary: Calc does not create or display graph plots correctly
           Product: LibreOffice
           Version: 6.4.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: athiril at gmail.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200131/de206cbc/attachment-0001.htm>