Package: libreoffice-calc Version: 1:5.1.4~rc2-2 Severity: important LibreOffice Calc violates the CSV specification in two ways. One (see the attached mwe1.csv): if a string field ends with a backslash, the terminating double quote is taken to be part of the cell content. Screenshots: • mwe1.png (LibreOffice) shown to handle it wrong • mwe1smo.png (SoftMaker FreeOffice PlanMaker) shown to handle it right Two (see the attached mwe2.csv): if a string field contains a double-quote, the field is not correctly terminated either. Screenshot: mwe2.png – expected similar to mwe1smo.png except without the backslash (which is the only byte mwe{1,2}.csv differ from each other). -- System Information: Debian Release: stretch/sid APT prefers buildd-unstable APT policy: (500, 'buildd-unstable'), (500, 'unstable') Architecture: amd64 (x86_64) Kernel: Linux 4.6.0-1-amd64 (SMP w/4 CPU cores) Locale: LANG=C, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/lksh Init: sysvinit (via /sbin/init) Versions of packages libreoffice-calc depends on: ii coinor-libcbc3 2.8.12-1+b1 ii coinor-libcoinmp1v5 1.7.6+dfsg1-2 ii dpkg 1.18.9 ii libboost-filesystem1.58.0 1.58.0+dfsg-5.1 ii libboost-iostreams1.58.0 1.58.0+dfsg-5.1 ii libc6 2.23-1 ii libetonyek-0.1-1 0.1.6-2 ii libgcc1 1:6.1.1-9 ii libicu55 55.1-7 ii liblcms2-2 2.7-1 ii libmwaw-0.3-3 0.3.7-1 ii libodfgen-0.1-1 0.1.6-1 ii liborcus-0.11-0 0.11.2-2 ii libreoffice-base-core 1:5.1.4~rc2-2 ii libreoffice-core 1:5.1.4~rc2-2 ii librevenge-0.0-0 0.0.4-4 ii libstdc++6 6.1.1-9 ii libwps-0.4-4 0.4.3-3 ii libxml2 2.9.3+dfsg1-1.2tarent2 ii lp-solve 5.5.0.15-4 ii uno-libs3 5.1.4~rc2-2 ii ure 5.1.4~rc2-2 ii zlib1g 1:1.2.8.dfsg-2+b1 libreoffice-calc recommends no packages. Versions of packages libreoffice-calc suggests: pn ocl-icd-libopencl1 <none> Versions of packages libreoffice-core depends on: ii fontconfig 2.11.0-6.4 ii fonts-opensymbol 2:102.7+LibO5.1.4~rc2-2 ii libboost-date-time1.58.0 1.58.0+dfsg-5.1 ii libc6 2.23-1 ii libcairo2 1.14.6-1+b1 ii libclucene-contribs1v5 2.3.3.4-4.1 ii libclucene-core1v5 2.3.3.4-4.1 ii libcmis-0.5-5v5 0.5.1-4 ii libcups2 2.1.4-4 ii libcurl3-gnutls 7.47.0-1 ii libdbus-1-3 1.10.8-1 ii libdbus-glib-1-2 0.106-1 ii libdconf1 0.26.0-1 ii libeot0 0.01-3 ii libexpat1 2.2.0-1 ii libexttextcat-2.0-0 3.4.4-1 ii libfontconfig1 2.11.0-6.4 ii libfreetype6 2.6.3-3+b1 ii libgcc1 1:6.1.1-9 ii libgl1-mesa-glx [libgl1] 11.2.2-1 ii libglew1.13 1.13.0-2 ii libglib2.0-0 2.48.1-2 ii libgltf-0.0-0v5 0.0.2-4+b1 ii libglu1-mesa [libglu1] 9.0.0-2.1 ii libgraphite2-3 1.3.8-1 ii libharfbuzz-icu0 1.2.6-2 ii libharfbuzz0b 1.2.6-2 ii libhunspell-1.4-0 1.4.1-2 ii libhyphen0 2.8.8-3 ii libice6 2:1.0.9-1+b1 ii libicu55 55.1-7 ii libjpeg62-turbo 1:1.5.0-1 ii liblangtag1 0.5.7-2 ii liblcms2-2 2.7-1 ii libldap-2.4-2 2.4.42+dfsg-2+b2 ii libmythes-1.2-0 2:1.2.4-1 ii libneon27-gnutls 0.30.1-3 ii libnspr4 2:4.12-2 ii libnss3 2:3.23-2 ii libodfgen-0.1-1 0.1.6-1 ii libpcre3 2:8.38-3.1 ii libpng16-16 1.6.23-1 ii librdf0 1.0.17-1+b1 ii libreoffice-common 1:5.1.4~rc2-2 ii librevenge-0.0-0 0.0.4-4 ii libsm6 2:1.2.2-1+b1 ii libssl1.0.2 1.0.2h-1 ii libstdc++6 6.1.1-9 ii libx11-6 2:1.6.3-1 ii libxext6 2:1.3.3-1 ii libxinerama1 2:1.1.3-1+b1 ii libxml2 2.9.3+dfsg1-1.2tarent2 ii libxrandr2 2:1.5.0-1 ii libxrender1 1:0.9.9-2 ii libxslt1.1 1.1.28-4 ii uno-libs3 5.1.4~rc2-2 ii ure 5.1.4~rc2-2 ii zlib1g 1:1.2.8.dfsg-2+b1 -- no debconf information
"City","Name","Comment","eMail" "Terrania","Some Organisation\",""quoted"","foo@example.com"
Attachment:
mwe1.png
Description: PNG image
Attachment:
mwe1smo.png
Description: PNG image
"City","Name","Comment","eMail" "Terrania","Some Organisation",""quoted"","foo@example.com"
Attachment:
mwe2.png
Description: PNG image