Skip Menu |
 
rt.cpan.org will be shut down on March 1st, 2021.

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

Report information
The Basics
Id: 86663
Status: new
Priority: 0/
Queue: Spreadsheet-XLSX

People
Owner: mikeb [...] cpan.org
Requestors: eff.ess [...] web.de
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Subject: Bug in parsing XLSX
Date: Wed, 3 Jul 2013 08:23:12 +0200 (CEST)
To: bug-Spreadsheet-XLSX [...] rt.cpan.org
From: "Felix Schnellinger" <eff.ess [...] web.de>
 
Hi there,
 
the attached spreadsheet produces errors when creating a new xlsx object
perl code:
my $excel = Spreadsheet::XLSX -> new ($infile);
 
output:
Argument "<f>" isn't numeric in int at /usr/local/share/perl/5.10.1/Spreadsheet/XLSX/Fmt2007.pm line 96.
 
I believe the following patch in XLSX.pm will solve the problem. Solution: When parsing the xlsx, check for closing AND EMPTY v-Tags before checking for opening v-tags
 
diff:
 
175a176,178
>                                            elsif (/^<\/v/ || /^<v\/>/) {
>                                                            $flag = 0;
>                                            }
178,180d180
<                                            }
<                                            elsif (/^<\/v/) {
<                                                            $flag = 0;
 
 
 
Please give me some feedback.
 
Best regards,
Felix Schnellinger
Download test.xlsx
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet 12.4k

Message body not shown because it is not plain text.



This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

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