[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#852329: marked as done (libreoffice-calc: mishandles backslashes and double-quotes during CSV import)

Your message dated Mon, 23 Jan 2017 23:16:35 +0100
with message-id <20170123221634.GH24701@rene-engelhard.de>
and subject line Re: Bug#852329: libreoffice-calc: mishandles backslashes and double-quotes during CSV import
has caused the Debian Bug report #852329,
regarding libreoffice-calc: mishandles backslashes and double-quotes during CSV import
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 owner@bugs.debian.org
immediately.)


-- 
852329: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=852329
Debian Bug Tracking System
Contact owner@bugs.debian.org with problems
--- Begin Message --- 
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


--- End Message ---
--- Begin Message --- 
Version: 1:5.2.0~beta1-1

Hi,

On Mon, Jan 23, 2017 at 09:11:51PM +0100, Rene Engelhard wrote:
> On Mon, Jan 23, 2017 at 05:13:50PM +0100, Thorsten Glaser wrote:
> > Package: libreoffice-calc
> > Version: 1:5.1.4~rc2-2
> > Severity: important
> 
> Why reporting on this ooold version?
> 
> > LibreOffice Calc violates the CSV specification in two ways.
> 
> Does it still happen in 5.2.4 as in stretch/sid? (Which is what you apparently
> are aiming to use, so...)

I see https://cgit.freedesktop.org/libreoffice/core/commit/?id=2049e55f507b00cf70f72706900e75d20ff3bb30.

April/May, so definitely in any current release.
Looking at the brahcnes' history it first appeared in a official release
in 5.2.0 (and before that in 1:5.2.0~beta1-1)

Closing.

Regards,

Rene

--- End Message ---
Reply to: