|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, 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.