Subject: | Missing value for referenced columns with space at the end |
Date: | Wed, 14 Nov 2018 13:10:59 +0100 |
To: | bug-Spreadsheet-XLSX [...] rt.cpan.org |
From: | "Rolf S." <rolf [...] r-schmidt-gmbh.de> |
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
Message body not shown because it is not plain text.
Message body is not shown because sender requested not to inline it.