Bug related to parsing of file Example_Book1X.xlsx using ParseXLSX version 0.27. The .xlsx file was NOT created with Excel.
perl code used to generate the bug:
use strict;
use warnings;
use Spreadsheet::ParseXLSX;
my $UUIDName='Example_Book1X.xlsx';
my $parser = Spreadsheet::ParseXLSX->new();
my $workbook = $parser->parse($UUIDName);
Result:
Use of uninitialized value $col in split at /usr/share/perl5/vendor_perl/Spreadsheet/ParseXLSX.pm line 1015.
Use of uninitialized value $row in subtraction (-) at /usr/share/perl5/vendor_perl/Spreadsheet/ParseXLSX.pm line 1021.
mismatched coords: got a1 for cell in row 0 at /usr/share/perl5/vendor_perl/Spreadsheet/ParseXLSX.pm line 339.
Comments:
1.) Bug is related to the fact that module cannot handle 'c' tags with 'r' attribute that contain lower case letters. These tags are present in the internal sheet(x).xml files
2.) Opening and saving the file with Excel resolves the problem.
Bug related to parsing of file Example_Book1X.xlsx using ParseXLSX version 0.27. The .xlsx file was NOT created with Excel.
perl code used to generate the bug:
use strict; use warnings; use Spreadsheet::ParseXLSX;
my $UUIDName='Example_Book1X.xlsx'; my $parser = Spreadsheet::ParseXLSX->new(); my $workbook = $parser->parse($UUIDName);
Result: Use of uninitialized value $col in split at /usr/share/perl5/vendor_perl/Spreadsheet/ParseXLSX.pm line 1015. Use of uninitialized value $row in subtraction (-) at /usr/share/perl5/vendor_perl/Spreadsheet/ParseXLSX.pm line 1021. mismatched coords: got a1 for cell in row 0 at /usr/share/perl5/vendor_perl/Spreadsheet/ParseXLSX.pm line 339.
Comments: 1.) Bug is related to the fact that module cannot handle 'c' tags with 'r' attribute that contain lower case letters. These tags are present in the internal sheet(x).xml files 2.) Opening and saving the file with Excel resolves the problem.