Bug#829300: libreoffice-calc: Chart, x-y scatter with Sort by X values breaks with empty cells

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Bug#829300: libreoffice-calc: Chart, x-y scatter with Sort by X values breaks with empty cells

Shannon Dealy
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.


-- System Information:
Debian Release: 8.5
  APT prefers stable-updates
  APT policy: (990, 'stable-updates'), (990, 'stable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 3.16.0-4-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: sysvinit (via /sbin/init)

Versions of packages libreoffice-calc depends on:
ii  coinor-libcbc3            2.8.12-1
ii  coinor-libcoinmp1         1.7.6+dfsg1-1
ii  libboost-iostreams1.55.0  1.55.0+dfsg-3
ii  libc6                     2.19-18+deb8u4
ii  libgcc1                   1:4.9.2-10
ii  libicu52                  52.1-8+deb8u3
ii  liblcms2-2                2.6-3+b3
ii  libmwaw-0.3-3             0.3.1-2
ii  libodfgen-0.1-1           0.1.1-2
ii  liborcus-0.8-0            0.7.0+dfsg-9
ii  libreoffice-base-core     1:4.3.3-2+deb8u4
ii  libreoffice-core          1:4.3.3-2+deb8u4
ii  librevenge-0.0-0          0.0.1-3
ii  libstdc++6                4.9.2-10
ii  libwps-0.3-3              0.3.0-2
ii  libxml2                   2.9.1+dfsg1-5+deb8u2
ii  lp-solve                  5.5.0.13-7+b1
ii  uno-libs3                 4.3.3-2+deb8u4
ii  ure                       4.3.3-2+deb8u4
ii  zlib1g                    1:1.2.8.dfsg-2+b1

libreoffice-calc recommends no packages.

Versions of packages libreoffice-calc suggests:
ii  ocl-icd-libopencl1  2.2.3-1+deb8u1

Versions of packages libreoffice-core depends on:
ii  fontconfig                2.11.0-6.3
ii  fonts-opensymbol          2:102.6+LibO4.3.3-2+deb8u4
ii  libatk1.0-0               2.14.0-1
ii  libboost-date-time1.55.0  1.55.0+dfsg-3
ii  libc6                     2.19-18+deb8u4
ii  libcairo2                 1.14.0-2.1+deb8u1
ii  libclucene-contribs1      2.3.3.4-4
ii  libclucene-core1          2.3.3.4-4
ii  libcmis-0.4-4             0.4.1-7
ii  libcups2                  1.7.5-11+deb8u1
ii  libcurl3-gnutls           7.38.0-4+deb8u3
ii  libdbus-1-3               1.8.20-0+deb8u1
ii  libdbus-glib-1-2          0.102-1
ii  libeot0                   0.01-3
ii  libexpat1                 2.1.0-6+deb8u3
ii  libexttextcat-2.0-0       3.4.4-1
ii  libfontconfig1            2.11.0-6.3
ii  libfreetype6              2.5.2-3+deb8u1
ii  libgcc1                   1:4.9.2-10
ii  libgdk-pixbuf2.0-0        2.31.1-2+deb8u5
ii  libgl1-mesa-glx [libgl1]  10.3.2-1+deb8u1
ii  libglew1.10               1.10.0-3
ii  libglib2.0-0              2.42.1-1+b1
ii  libgltf-0.0-0             0.0.2-2
ii  libglu1-mesa [libglu1]    9.0.0-2
ii  libgraphite2-3            1.3.6-1~deb8u1
ii  libgtk2.0-0               2.24.25-3+deb8u1
ii  libharfbuzz-icu0          0.9.35-2
ii  libharfbuzz0b             0.9.35-2
ii  libhunspell-1.3-0         1.3.3-3
ii  libhyphen0                2.8.8-1
ii  libice6                   2:1.0.9-1+b1
ii  libicu52                  52.1-8+deb8u3
ii  libjpeg62-turbo           1:1.3.1-12
ii  liblangtag1               0.5.1-3
ii  liblcms2-2                2.6-3+b3
ii  libldap-2.4-2             2.4.40+dfsg-1+deb8u2
ii  libmythes-1.2-0           2:1.2.4-1
ii  libneon27-gnutls          0.30.1-1
ii  libnspr4                  2:4.10.7-1+deb8u1
ii  libnspr4-0d               2:4.10.7-1+deb8u1
ii  libnss3                   2:3.17.2-1.1+deb8u2
ii  libnss3-1d                2:3.17.2-1.1+deb8u2
ii  libodfgen-0.1-1           0.1.1-2
ii  libpango-1.0-0            1.36.8-3
ii  libpangocairo-1.0-0       1.36.8-3
ii  libpangoft2-1.0-0         1.36.8-3
ii  libpng12-0                1.2.50-2+deb8u2
ii  librdf0                   1.0.17-1+b1
ii  libreoffice-common        1:4.3.3-2+deb8u4
ii  librevenge-0.0-0          0.0.1-3
ii  libsm6                    2:1.2.2-1+b1
ii  libssl1.0.0               1.0.1t-1+deb8u2
ii  libstdc++6                4.9.2-10
ii  libx11-6                  2:1.6.2-3
ii  libxext6                  2:1.3.3-1
ii  libxinerama1              2:1.1.3-1+b1
ii  libxml2                   2.9.1+dfsg1-5+deb8u2
ii  libxrandr2                2:1.4.2-1+b1
ii  libxrender1               1:0.9.8-1+b1
ii  libxslt1.1                1.1.28-2+deb8u1
ii  libxt6                    1:1.1.4-1+b1
ii  uno-libs3                 4.3.3-2+deb8u4
ii  ure                       4.3.3-2+deb8u4
ii  zlib1g                    1:1.2.8.dfsg-2+b1

-- debconf-show failed

Reply | Threaded
Open this post in threaded view
|

Bug#829300: - supplemental file

Shannon Dealy

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.
[hidden email]          |    - Custom Software Development -
Telephone: +1 541-929-4089 |    - Natural Building Instruction -
USA only:     800-467-5820 |            www.deatech.com

Chart-sort-by-X-bug.ods (29K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Bug#829300: marked as done (libreoffice-calc: Chart, x-y scatter with Sort by X values breaks with empty cells)

Debian Bug Tracking System
In reply to this post by Shannon Dealy
Your message dated Mon, 13 May 2019 16:44:21 +0000
with message-id <[hidden email]>
and subject line libreoffice-calc: Chart, x-y scatter with Sort by X values breaks with empty cells
has caused the Debian Bug report #829300,
regarding libreoffice-calc: Chart, x-y scatter with Sort by X values breaks with empty cells
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [hidden email]
immediately.)


--
829300: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=829300
Debian Bug Tracking System
Contact [hidden email] with problems

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.


-- System Information:
Debian Release: 8.5
  APT prefers stable-updates
  APT policy: (990, 'stable-updates'), (990, 'stable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 3.16.0-4-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: sysvinit (via /sbin/init)

Versions of packages libreoffice-calc depends on:
ii  coinor-libcbc3            2.8.12-1
ii  coinor-libcoinmp1         1.7.6+dfsg1-1
ii  libboost-iostreams1.55.0  1.55.0+dfsg-3
ii  libc6                     2.19-18+deb8u4
ii  libgcc1                   1:4.9.2-10
ii  libicu52                  52.1-8+deb8u3
ii  liblcms2-2                2.6-3+b3
ii  libmwaw-0.3-3             0.3.1-2
ii  libodfgen-0.1-1           0.1.1-2
ii  liborcus-0.8-0            0.7.0+dfsg-9
ii  libreoffice-base-core     1:4.3.3-2+deb8u4
ii  libreoffice-core          1:4.3.3-2+deb8u4
ii  librevenge-0.0-0          0.0.1-3
ii  libstdc++6                4.9.2-10
ii  libwps-0.3-3              0.3.0-2
ii  libxml2                   2.9.1+dfsg1-5+deb8u2
ii  lp-solve                  5.5.0.13-7+b1
ii  uno-libs3                 4.3.3-2+deb8u4
ii  ure                       4.3.3-2+deb8u4
ii  zlib1g                    1:1.2.8.dfsg-2+b1

libreoffice-calc recommends no packages.

Versions of packages libreoffice-calc suggests:
ii  ocl-icd-libopencl1  2.2.3-1+deb8u1

Versions of packages libreoffice-core depends on:
ii  fontconfig                2.11.0-6.3
ii  fonts-opensymbol          2:102.6+LibO4.3.3-2+deb8u4
ii  libatk1.0-0               2.14.0-1
ii  libboost-date-time1.55.0  1.55.0+dfsg-3
ii  libc6                     2.19-18+deb8u4
ii  libcairo2                 1.14.0-2.1+deb8u1
ii  libclucene-contribs1      2.3.3.4-4
ii  libclucene-core1          2.3.3.4-4
ii  libcmis-0.4-4             0.4.1-7
ii  libcups2                  1.7.5-11+deb8u1
ii  libcurl3-gnutls           7.38.0-4+deb8u3
ii  libdbus-1-3               1.8.20-0+deb8u1
ii  libdbus-glib-1-2          0.102-1
ii  libeot0                   0.01-3
ii  libexpat1                 2.1.0-6+deb8u3
ii  libexttextcat-2.0-0       3.4.4-1
ii  libfontconfig1            2.11.0-6.3
ii  libfreetype6              2.5.2-3+deb8u1
ii  libgcc1                   1:4.9.2-10
ii  libgdk-pixbuf2.0-0        2.31.1-2+deb8u5
ii  libgl1-mesa-glx [libgl1]  10.3.2-1+deb8u1
ii  libglew1.10               1.10.0-3
ii  libglib2.0-0              2.42.1-1+b1
ii  libgltf-0.0-0             0.0.2-2
ii  libglu1-mesa [libglu1]    9.0.0-2
ii  libgraphite2-3            1.3.6-1~deb8u1
ii  libgtk2.0-0               2.24.25-3+deb8u1
ii  libharfbuzz-icu0          0.9.35-2
ii  libharfbuzz0b             0.9.35-2
ii  libhunspell-1.3-0         1.3.3-3
ii  libhyphen0                2.8.8-1
ii  libice6                   2:1.0.9-1+b1
ii  libicu52                  52.1-8+deb8u3
ii  libjpeg62-turbo           1:1.3.1-12
ii  liblangtag1               0.5.1-3
ii  liblcms2-2                2.6-3+b3
ii  libldap-2.4-2             2.4.40+dfsg-1+deb8u2
ii  libmythes-1.2-0           2:1.2.4-1
ii  libneon27-gnutls          0.30.1-1
ii  libnspr4                  2:4.10.7-1+deb8u1
ii  libnspr4-0d               2:4.10.7-1+deb8u1
ii  libnss3                   2:3.17.2-1.1+deb8u2
ii  libnss3-1d                2:3.17.2-1.1+deb8u2
ii  libodfgen-0.1-1           0.1.1-2
ii  libpango-1.0-0            1.36.8-3
ii  libpangocairo-1.0-0       1.36.8-3
ii  libpangoft2-1.0-0         1.36.8-3
ii  libpng12-0                1.2.50-2+deb8u2
ii  librdf0                   1.0.17-1+b1
ii  libreoffice-common        1:4.3.3-2+deb8u4
ii  librevenge-0.0-0          0.0.1-3
ii  libsm6                    2:1.2.2-1+b1
ii  libssl1.0.0               1.0.1t-1+deb8u2
ii  libstdc++6                4.9.2-10
ii  libx11-6                  2:1.6.2-3
ii  libxext6                  2:1.3.3-1
ii  libxinerama1              2:1.1.3-1+b1
ii  libxml2                   2.9.1+dfsg1-5+deb8u2
ii  libxrandr2                2:1.4.2-1+b1
ii  libxrender1               1:0.9.8-1+b1
ii  libxslt1.1                1.1.28-2+deb8u1
ii  libxt6                    1:1.1.4-1+b1
ii  uno-libs3                 4.3.3-2+deb8u4
ii  ure                       4.3.3-2+deb8u4
ii  zlib1g                    1:1.2.8.dfsg-2+b1

-- debconf-show failed

hello,

Still valid with LO 6.0.6.2. Please follow this bug at :

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

Regards,

--
St├ęphane Aulery
Reply | Threaded
Open this post in threaded view
|

Re: Bug#829300: marked as done (libreoffice-calc: Chart, x-y scatter with Sort by X values breaks with empty cells)

Rene Engelhard
Hi,

just taking this bug as an example.

On Mon, May 13, 2019 at 04:57:07PM +0000, Debian Bug Tracking System wrote:
> Your message dated Mon, 13 May 2019 16:44:21 +0000
> with message-id <[hidden email]>
> and subject line libreoffice-calc: Chart, x-y scatter with Sort by X values breaks with empty cells
> has caused the Debian Bug report #829300,
> regarding libreoffice-calc: Chart, x-y scatter with Sort by X values breaks with empty cells
> to be marked as done.

This is not how it works, if it still is a upstream bug mark it as
forwarded to this bug. BUT DO NOT CLOSE IT. This list also serves a a
reference to people. And forwarded bug which are there until infinity
are not a problem per se as documentation that upstream didn't care
about this bug so far.

(And there's bts-link updating statuses, which also break if the bug is
closed).

Please revert your bogus bug closings immediately, and if it wasn't marked
as forwarded yet mark it as forwarded.

> Still valid with LO 6.0.6.2. Please follow this bug at :
>
> https://bugs.documentfoundation.org/show_bug.cgi?id=112787

So why close this bug? It's valid.

Regards,

Rene