| Subject: | Warnings opening xlsx files created with Libre Office |
| Date: | Thu, 20 Sep 2012 15:43:42 -0400 |
| To: | bug-Spreadsheet-XLSX [...] rt.cpan.org |
| From: | Robert Crown <rcrown [...] atpcan.com> |
Mr Ovsyanko and team,
Thanks for your work on Spreadhseet::XLSX. I've found it very
helpful, even though I have only limited perl experience.
I've found a problem when reading .xlsx files created with Libre
Office. I'm not sure if you're interested in compatibility with Libre
office, but if you are, the message I get is:
Show quoted text
> Use of uninitialized value within @styles in hash element at /usr/local/share/perl5/Spreadsheet/XLSX.pm line 189.
> Use of uninitialized value $thisstyle in pattern match (m//) at /usr/local/share/perl5/Spreadsheet/XLSX.pm line 190.
I get this when running the attached script on the attached file. It
seems to have something to do with the way Libre office writes the style
info. Each cell seems to have, for example,
Show quoted text> <c r="A1" s="0" t="s">
And in the native .xlsx files, I don't see such a thing, so it could be
this which is causing the warning.
Below are the other details of my environment:
Distribution name and version:
0.13
Perl Version:
This is perl 5, version 12, subversion 4 (v5.12.4) built for
i386-linux-thread-multi
Operating System vendor and version:
Linux prometheus 2.6.35.14-106.fc14.i686 #1 SMP Wed Nov 23 13:57:33 UTC
2011 i686 i686 i386 GNU/Linux
Libre Office:
Version 3.6.0.4 (Build ID: 932b512)
Regards,
Bob Crown
Message body not shown because it is not plain text.
Message body is not shown because sender requested not to inline it.