Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error using ParseXLSX version 0.27 related to case sensitivity of <c> tags 'r' attribute #16

Open
acggith opened this issue Apr 17, 2024 · 0 comments
Assignees
Labels
bug Something isn't working

Comments

@acggith
Copy link

acggith commented Apr 17, 2024

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.

@MichaelDaum MichaelDaum self-assigned this Apr 17, 2024
@MichaelDaum MichaelDaum added the bug Something isn't working label Apr 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants