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"","f...@example.com"
"City","Name","Comment","eMail"
"Terrania","Some Organisation",""quoted"","f...@example.com"
