Skip Menu |
 
rt.cpan.org will be shut down on March 1st, 2021.

This queue is for tickets about the Spreadsheet-XLSX CPAN distribution.

Report information
The Basics
Id: 79770
Status: new
Priority: 0/
Queue: Spreadsheet-XLSX

People
Owner: Nobody in particular
Requestors: rcrown [...] atpcan.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



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>
Download (untitled) / with headers
text/plain 1.2k
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
Download testing2.xlsx
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet 5.5k

Message body not shown because it is not plain text.

Download libre_bug.pl
text/x-perl 99b

Message body is not shown because sender requested not to inline it.



This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.