[Libreoffice-bugs] [Bug 112787] New: Chart, x-y scatter with Sort by X values breaks with empty cells

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 112787
           Summary: Chart, x-y scatter with Sort by X values breaks with
                    empty cells
           Product: LibreOffice
           Version: 5.4.1.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: lkppo at free.fr

Created attachment 136655
  --> https://bugs.documentfoundation.org/attachment.cgi?id=136655&action=edit
Chart-sort-by-X-bug.ods

From: Shannon Dealy <dealy at deatech.com>
To: Debian Bug Tracking System <submit at bugs.debian.org>
Subject: libreoffice-calc: Chart, x-y scatter with Sort by X values breaks with
empty cells
Date: Sat, 02 Jul 2016 10:49:37 +0200

Package: libreoffice-calc
Version: 1:4.3.3-2+deb8u4
Severity: normal

Dear Maintainer,

I selected two columns of cells in a spreadsheet which had empty cells
between the rows of data in these columns, however, a filter was turned on
which displayed only the non-empty rows for these columns. I created an X-Y
scatter plot with points and lines in calc, with the "Sort by X values"
option and the chart was correctly created. Once the filter was turned off,
displaying the empty cells, the points remained in the correct places, however,
the order of the lines was rearranged so that the X sorting was no longer
being correctly observed. I had naturally expected that the chart would
not be affected by the filter being removed as only empty cells were added.

Some experimentation has shown that it is not the filter, but some strange
function of the number of empty cells between the rows that have data.
With the filter turned off and just inserting and deleting empty rows I get
different plots for the exact same data, given in the exact same order.
I created a spreadsheet with nothing but the data being ploted and a chart
and found that the order of the line plotting changed depending on the
number of rows of empty cells between the different rows of data values.
In other words, it does not just fail to sort the rows by the X value when
there are empty cells, but the order it uses for the plot changes based
on where and how many empty rows there are between the data values.


The attached file can be used to demonstrate the bug.

 - Select "not empty" for the Y column filter and the chart will display
   correctly, sorted by the X values.

 - Change the filter selection so all rows display again. This will
   make the chart return to its original incorrect display

 - Now select cells B8 - C11 and delete them with the option to move
   cells up. The chart will now display incorrectly in a different
   manner, even though the data has not changed and remains in the
   same order, only empty cells have been removed.

 - Other changes to the number of rows of empty cells can result
   different versions of the wrong display.

Regards,

Shannon C. Dealy           |         DeaTech Research Inc.
dealy at deatech.com          |    - Custom Software Development -
Telephone: +1 541-929-4089 |    - Natural Building Instruction -
USA only:     800-467-5820 |            www.deatech.com

-- 
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/20170930/8149ad2b/attachment.html>