Created attachment 947033 [details] xlsx file which demonstrates the bug Description of problem: If a cell contains the text value "0" (without quotes), and that value gets saved in the shared string table, parsing will return empty value instead of the digit 0. Version-Release number of selected component (if applicable): perl-Spreadsheet-XLSX-0.13-5.fc20.noarch How reproducible: Always Steps to Reproduce: 1. See attached XLSX file. 2. 3. Actual results: Parsing produces cell value of empty string Expected results: Parsing produces cell value of digit 0 (ie. "0") Additional info: This bug was introduced by the patch "perl-Spreadsheet-XLSX-0.13-warnings.patch" that is added into the Fedora version of the package. In that patch, a CPAN bug is referenced (https://rt.cpan.org/Public/Bug/Display.html?id=84528) however the implementation in the RPM differs from the one in the bug report in one critical aspect (which causes the bug): Line 49 in patch from RPM: $str .= $t if $t; Line 49 from CPAN bug report; $str .= $t if defined($t); In this case $t = "0", so it is false, but is defined. I have verified that changing line 49 from ... if ($t) to .. if defined($t) fixes the issue.
perl-Spreadsheet-XLSX-0.13-8.fc21 has been submitted as an update for Fedora 21. https://admin.fedoraproject.org/updates/perl-Spreadsheet-XLSX-0.13-8.fc21
perl-Spreadsheet-XLSX-0.13-8.fc20 has been submitted as an update for Fedora 20. https://admin.fedoraproject.org/updates/perl-Spreadsheet-XLSX-0.13-8.fc20
perl-Spreadsheet-XLSX-0.13-8.fc19 has been submitted as an update for Fedora 19. https://admin.fedoraproject.org/updates/perl-Spreadsheet-XLSX-0.13-8.fc19
perl-Spreadsheet-XLSX-0.13-8.el6 has been submitted as an update for Fedora EPEL 6. https://admin.fedoraproject.org/updates/perl-Spreadsheet-XLSX-0.13-8.el6
perl-Spreadsheet-XLSX-0.13-8.el5 has been submitted as an update for Fedora EPEL 5. https://admin.fedoraproject.org/updates/perl-Spreadsheet-XLSX-0.13-8.el5
Package perl-Spreadsheet-XLSX-0.13-8.fc21: * should fix your issue, * was pushed to the Fedora 21 testing repository, * should be available at your local mirror within two days. Update it with: # su -c 'yum update --enablerepo=updates-testing perl-Spreadsheet-XLSX-0.13-8.fc21' as soon as you are able to. Please go to the following url: https://admin.fedoraproject.org/updates/FEDORA-2014-12966/perl-Spreadsheet-XLSX-0.13-8.fc21 then log in and leave karma (feedback).
perl-Spreadsheet-XLSX-0.13-8.el7 has been submitted as an update for Fedora EPEL 7. https://admin.fedoraproject.org/updates/perl-Spreadsheet-XLSX-0.13-8.el7
perl-Spreadsheet-XLSX-0.13-8.fc20 has been pushed to the Fedora 20 stable repository. If problems still persist, please make note of it in this bug report.
perl-Spreadsheet-XLSX-0.13-8.fc19 has been pushed to the Fedora 19 stable repository. If problems still persist, please make note of it in this bug report.
perl-Spreadsheet-XLSX-0.13-8.fc21 has been pushed to the Fedora 21 stable repository. If problems still persist, please make note of it in this bug report.
perl-Spreadsheet-XLSX-0.13-8.el5 has been pushed to the Fedora EPEL 5 stable repository. If problems still persist, please make note of it in this bug report.
perl-Spreadsheet-XLSX-0.13-8.el6 has been pushed to the Fedora EPEL 6 stable repository. If problems still persist, please make note of it in this bug report.
perl-Spreadsheet-XLSX-0.13-8.el7 has been pushed to the Fedora EPEL 7 stable repository. If problems still persist, please make note of it in this bug report.