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
