Bug #127639 for Spreadsheet-XLSX: Missing value for referenced columns with space at the end

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