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

Report information
The Basics
Id:
79770
Status:
new
Priority:
Low/Low

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

BugTracker
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>
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.



This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

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