search

doy / spreadsheet-parsexlsx

parse XLSX files
http://metacpan.org/release/Spreadsheet-ParseXLSX
27 stars 35 forks source link

Bug fix for bad "dimension" spec. #91

Open berntb opened 5 years ago

berntb commented 5 years ago

Some programs (Libre Office) create XLSX files with a bad dimension spec. They only save max col/row.

This fix to Spreadsheet/ParseXLSX.pm should illustrate (and solve) the problem:

sub _dimensions {
     my $self = shift;
     my ($dim) = @_;

+    $dim  = "A1:$dim"
+        if $dim !~ /:/;