--- Begin Message ---
- To: Debian Bug Tracking System <submit@bugs.debian.org>
- Subject: libreoffice-calc: Chart, x-y scatter with Sort by X values breaks with empty cells
- From: Shannon Dealy <dealy@deatech.com>
- Date: Sat, 02 Jul 2016 10:49:37 +0200
- Message-id: <20160702084937.25148.93328.reportbug@nashapur.deatech.com>
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
--- End Message ---