|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 22.214.171.124-106.fc14.i686 #1 SMP Wed Nov 23 13:57:33 UTC 2011 i686 i686 i386 GNU/Linux Libre Office: Version 126.96.36.199 (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.