This queue is for tickets about the Spreadsheet-XLSX CPAN distribution.

Report information
The Basics
Id:
127639
Status:
new
Priority:
Low/Low

People
Owner:
Nobody in particular
Requestors:
rolf [...] r-schmidt-gmbh.de
Cc:
AdminCc:

BugTracker
Severity:
(no value)
Broken in:
(no value)
Fixed in:
(no value)



MIME-Version: 1.0
X-Spam-Status: No, score=-1.999 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=0.001] autolearn=ham
X-Cpan.org: This message routed through the cpan.org mail forwarding service. Please use PAUSE pause.perl.org to configure your delivery settings.
X-RZG-Class-ID: mo00
X-Spam-Flag: NO
Content-Type: multipart/mixed; boundary="0000000000009a9399057a9ed47a"
Message-ID: <CABr+1CCeWR1H6XMe6qwUU4mqVAbAymB4nR1DQ5DqrXngxZjvhg@mail.gmail.com>
X-Received: by 2002:a24:15c3:: with SMTP id 186-v6mr1648793itq.67.1542197473848; Wed, 14 Nov 2018 04:11:13 -0800 (PST)
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Spam-Score: -1.999
X-Google-SMTP-Source: AFSGD/WRrfCJLzfsIvi+CJgaTbPiIs9kvUEQOarKSipBGqGsH/2mU4BY35Q0/Qc4mrEze7HQyxPVAcDRxsvoHh+1T0M=
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 8131D240274 for <cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com>; Wed, 14 Nov 2018 07:17:40 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id DiXhEEdC19cU for <cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com>; Wed, 14 Nov 2018 07:17:37 -0500 (EST)
Received: from xx1.develooper.com (xx1.develooper.com [207.171.7.115]) by hipster.bestpractical.com (Postfix) with ESMTPS id 3AA312400C0 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Wed, 14 Nov 2018 07:17:36 -0500 (EST)
Received: from localhost (xx1.develooper.com [127.0.0.1]) by localhost (Postfix) with ESMTP id 8016111F193 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Wed, 14 Nov 2018 04:17:35 -0800 (PST)
Received: from xx1.develooper.com (xx1.develooper.com [127.0.0.1]) by localhost (Postfix) with SMTP id ECB441205D0 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Wed, 14 Nov 2018 04:17:31 -0800 (PST)
Received: from mo4-p00-ob.smtp.rzone.de (mo4-p00-ob.smtp.rzone.de [81.169.146.217]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) by xx1.develooper.com (Postfix) with ESMTPS id 9E56E11F193 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Wed, 14 Nov 2018 04:17:29 -0800 (PST)
Received: from mail-it1-f182.google.com by smtp.strato.de (RZmta 44.4 AUTH) with ESMTPSA id Z09ed9uAECBF03R (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (curve secp384r1 with 384 ECDH bits, eq. 7680 bits RSA)) (Client did not present a certificate) for <bug-Spreadsheet-XLSX@rt.cpan.org>; Wed, 14 Nov 2018 13:11:15 +0100 (CET)
Received: by mail-it1-f182.google.com with SMTP id p11-v6so16040799itf.0 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Wed, 14 Nov 2018 04:11:14 -0800 (PST)
Authentication-Results: hipster.bestpractical.com (amavisd-new); dkim=pass header.i=@r-schmidt-gmbh.de
Delivered-To: cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com
Subject: Missing value for referenced columns with space at the end
Return-Path: <rolf@r-schmidt-gmbh.de>
X-RT-Mail-Extension: spreadsheet-xlsx
X-Original-To: cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com
Dkim-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; t=1542197848; s=strato-dkim-0002; d=r-schmidt-gmbh.de; h=To:Subject:Message-ID:Date:From:X-RZG-CLASS-ID:X-RZG-AUTH:From: Subject:Sender; bh=x/3WWphTtR24qyzQLAKdQ6Sqm7g2dL0FCCGL3Ae1tUQ=; b=KKB3KpjBcgbm4ieH8YQqXvHgF7ifMFgPoAPtW1cHe58w/SjApyerTpzupX0v05kjIx vSWwCnqGn5KF9eC2RIbaWut/GY6eY34b0NL6U/GnHYYBbGf6IssFZPPeO0NjebY38FOW TA4pXe5piQ+4QdPS/+8s0JV/uxsgZuZmf8hERx6sxRCkRMReXvfwXKxCKb77198Y4IO/ PregKYKRqzRX8zo7wgy/QMz0XRNPHjiqBXV1CcHiONMkpapQQanNl4PypPb8/pR8pxsA /Ctc2NNAKPO243e9iDVBseyQwAR/JzCpz3Su/SImbury/bz8OMEZkgGM9BYFoSNYx6W/ cXVw==
X-PMX-Spam: Gauge=IIIIIIII, Probability=8%, Report=' BODYTEXTH_SIZE_10000_LESS 0, BODYTEXTH_SIZE_3000_MORE 0, BODYTEXTP_SIZE_3000_LESS 0, BODY_SIZE_10000_PLUS 0, DKIM_ALIGNS 0, DKIM_SIGNATURE 0, HEX28_LC_NOT_GOOGLE 0, LEGITIMATE_SIGNS 0, MULTIPLE_APP_ATT 0, NO_URI_HTTPS 0, OFFICE_ATTACHED 0, SPF_NONE 0, XLSX_ATTACHED 0, __ANY_URI 0, __ATTACHMENT_SIZE_0_10K 0, __ATTACHMENT_SIZE_10_25K 0, __CP_URI_IN_BODY 0, __CT 0, __CTYPE_HAS_BOUNDARY 0, __CTYPE_MULTIPART 0, __CTYPE_MULTIPART_MIXED 0, __DKIM_ALIGNS_1 0, __DKIM_ALIGNS_2 0, __FRAUD_MONEY_CURRENCY 0, __FRAUD_MONEY_CURRENCY_DOLLAR 0, __HAS_ATTACHMENT 0, __HAS_ATTACHMENT1 0, __HAS_ATTACHMENT2 0, __HAS_FROM 0, __HAS_HTML 0, __HAS_MSGID 0, __HEX28_LC_BOUNDARY 0, __HIGHBITS 0, __HTML_AHREF_TAG 0, __HTML_TAG_DIV 0, __MIME_HTML 0, __MIME_TEXT_H 0, __MIME_TEXT_H1 0, __MIME_TEXT_H2 0, __MIME_TEXT_P 0, __MIME_TEXT_P1 0, __MIME_TEXT_P2 0, __MIME_VERSION 0, __MULTIPLE_URI_HTML 0, __MULTIPLE_URI_TEXT 0, __SANE_MSGID 0, __STOCK_PHRASE_24 0, __SUBJ_ALPHA_END 0, __TO_MALFORMED_2 0, __TO_NO_NAME 0, __URI_IN_BODY 0, __URI_NOT_IMG 0, __URI_NO_MAILTO 0, __URI_NS , __URI_NS_NXDOMAIN , __URI_WITHOUT_PATH 0, __URI_WITH_PATH 0, __XLSX_ATTACHED1 0, __XLSX_ATTACHED2 0, __YOUTUBE_RCVD 0, __zen.spamhaus.org_ERROR '
Date: Wed, 14 Nov 2018 13:10:59 +0100
X-RZG-Auth: ":PmMIc2C6NuwVaA1ngRTdubJLpt7qOb7xdX7RcOWqVJv0tR8cDbvxSDQjeSsW6dua8RxNDPmA"
X-Gmail-Original-Message-ID: <CABr+1CCeWR1H6XMe6qwUU4mqVAbAymB4nR1DQ5DqrXngxZjvhg@mail.gmail.com>
X-Spam-Level:
X-Greylist: delayed 178 seconds by postgrey-1.34 at xx1.develooper.com; Wed, 14 Nov 2018 04:17:30 PST
X-PMX-Version: 5.6.1.2065439, Antispam-Engine: 2.7.2.376379, Antispam-Data: 2018.11.14.121216
To: bug-Spreadsheet-XLSX@rt.cpan.org
From: "Rolf S." <rolf@r-schmidt-gmbh.de>
X-GM-Message-State: AGRZ1gL+U38Juphj/eEqkQ5zHRl+SCm+WF8X8vWkhSIc+WhA9P4rO0X3 Xa4rNoQjMVG4NC0aWDjmyVR4bLwz4YGNpV/gEcc=
X-RT-Interface: Email
Content-Length: 0
Content-Type: multipart/alternative; boundary="0000000000009a9396057a9ed478"
Content-Length: 0
content-type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: utf-8
Content-Length: 1949
content-type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: utf-8
Content-Length: 2819
Hello maintainer\s,
first of all i want to say that i really love your excel lib and it makes my time playing around with excel much more easier :-)

I think i found a bug for specifc case where columns are referenced between different worksheets.

In the attachments you can find an excel example and also a perl script which shows my problem.

My output looks like this:

$ perl bug_space.pl
Values for A2:
Data1: 'Haupt Str.'
Data2: 'Haupt Str.'

Values for A3 (ERROR HERE):
Data1: 'Haupt Str. '
Data2: ''


Values for A4:
Data1: 'Nebenstr.'
Data2: 'Nebenstr.'

So both worksheets Data1 and Data2 are containing the same value but it seems like that the value got lost for A3 of Data2.
If you remove the space at the end of A2 of Data1 then it works. There is something wrong with the space when the field get referenced and
i dont know why.

A colleague of mine tried to unpack it and saw that the value is stored differently:

<si><t>Haupt Str.</t></si>
<si><t xml:space="preserve">Haupt Str. </t></si>

My environment is the following:

$ perl -v

This is perl 5, version 22, subversion 1 (v5.22.1) built for x86_64-linux-gnu-thread-multi
(with 60 registered patches, see perl -V for more detail)

Copyright 1987-2015, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl".  If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.

$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 16.04.3 LTS
Release:        16.04
Codename:       xenial

$ perl -MSpreadsheet::XLSX -e 'print $Spreadsheet::XLSX::VERSION';
0.15

Vielleicht wisst ihr ja wieso das so ist und könnt mir helfen.

Thank you very much!

Best regards,
Rolf
X-Attachment-ID: f_joh478ff1
Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; name="bug_space.xlsx"
Content-Disposition: attachment; filename="bug_space.xlsx"
Content-Transfer-Encoding: base64
Content-ID: <f_joh478ff1>
Content-Length: 9602

Message body not shown because it is not plain text.

X-Attachment-ID: f_joh478f10
Content-Type: application/octet-stream; name="bug_space.pl"
Content-Disposition: attachment; filename="bug_space.pl"
Content-Transfer-Encoding: base64
Content-ID: <f_joh478f10>
Content-Length: 721

Message body is not shown because sender requested not to inline it.



This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.