Bug #79770 for Spreadsheet-XLSX: Warnings opening xlsx files created with Libre Office

X-Spam-Flag2999:	NO
MIME-Version:	1.0
X-Spam-Flag:	NO
X-Spam-Level2999:
Content-Type:	multipart/mixed; boundary="=-te6V2btdhsa9U/aQ/IMJ"
X-Virus-Scanned:	Debian amavisd-new at bestpractical.com
X-Source-Sender:	([192.168.254.242]) [173.86.138.90]:60673
X-Source-Cap:	YXRwY2FuO2F0cGNhbjtnYXRvcjk4Ni5ob3N0Z2F0b3IuY29t
X-Spam-Score:	-6.234
Received:	from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id AF3872407F6 for <cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com>; Thu, 20 Sep 2012 15:44:05 -0400 (EDT)
Received:	from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id T+pciPRdwwAK for <cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com>; Thu, 20 Sep 2012 15:44:04 -0400 (EDT)
Received:	from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 2C271240761 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Thu, 20 Sep 2012 15:44:02 -0400 (EDT)
Received:	(qmail 8653 invoked by uid 103); 20 Sep 2012 19:44:02 -0000
Received:	from x16.dev (10.0.100.26) by x1.dev with QMQP; 20 Sep 2012 19:44:02 -0000
Received:	from gateway07.websitewelcome.com (HELO gateway07.websitewelcome.com) (67.18.65.21) by 16.mx.develooper.com (qpsmtpd/0.84/v0.84-167-g4ed6cab) with ESMTP; Thu, 20 Sep 2012 12:43:59 -0700
Received:	by gateway07.websitewelcome.com (Postfix, from userid 5007) id CE04B26845160; Thu, 20 Sep 2012 14:43:55 -0500 (CDT)
Received:	from ham02.websitewelcome.com (unknown [173.192.111.51]) by gateway07.websitewelcome.com (Postfix) with ESMTP id 6721B26845124 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Thu, 20 Sep 2012 14:43:55 -0500 (CDT)
Received:	by ham02.websitewelcome.com (Postfix, from userid 666) id 898DDB9555C02; Thu, 20 Sep 2012 14:43:54 -0500 (CDT)
Received:	from gator986.hostgator.com (gator986.hostgator.com [174.120.119.34]) by ham02.websitewelcome.com (Postfix) with ESMTP id 3DD31B9553CBF for <bug-Spreadsheet-XLSX@rt.cpan.org>; Thu, 20 Sep 2012 14:43:49 -0500 (CDT)
Received:	from [173.86.138.90] (port=60673 helo=[192.168.254.242]) by gator986.hostgator.com with esmtpsa (SSLv3:CAMELLIA256-SHA:256) (Exim 4.77) (envelope-from <rcrown@atpcan.com>) id 1TEmf6-0003Qe-LB for bug-Spreadsheet-XLSX@rt.cpan.org; Thu, 20 Sep 2012 14:43:49 -0500
Delivered-To:	cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com
Subject:	Warnings opening xlsx files created with Libre Office
X-Spam-Check-BY:	16.mx.develooper.com
Date:	Thu, 20 Sep 2012 15:43:42 -0400
X-Spam-Level:
X-Bwhitelist:	no
To:	bug-Spreadsheet-XLSX@rt.cpan.org
From rcrown@atpcan.com Thu Sep 20 15:	44:05 2012
X-Source:
X-Spam-Status:	No, score=-6.234 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_HI=-5, SPF_SOFTFAIL=0.665] autolearn=ham
X-Source-Args:
X-Mailer:	Evolution 2.32.3 (2.32.3-1.fc14)
X-Source-Dir:
Message-ID:	<1348170222.8299.163.camel@prometheus>
X-Spam-Status2999:	"No, score=-1.9 required=5.0 tests=BAYES_00,HTML_MESSAGE autolearn=ham version=3.3.1
Organization:	ATP
X-Antiabuse:	This header was added to track abuse, please include it with any abuse report
X-Antiabuse:	Primary Hostname - gator986.hostgator.com
X-Antiabuse:	Original Domain - rt.cpan.org
X-Antiabuse:	Originator/Caller UID/GID - [47 12] / [47 12]
X-Antiabuse:	Sender Address Domain - atpcan.com
X-Source-Auth:	rcrown@atpcan.com
Return-Path:	<rcrown@atpcan.com>
X-Original-To:	cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com
X-RT-Mail-Extension:	spreadsheet-xlsx
X-Email-Count:	28
From:	Robert Crown <rcrown@atpcan.com>
Content-Length:	0

Content-Type:	multipart/alternative; boundary="=-1xZUpnUpSMhoNfclEA17"
Content-Length:	0

Content-Type:	text/plain; charset="UTF-8"
Content-Transfer-Encoding:	7bit
X-RT-Original-Encoding:	utf-8
Content-Length:	1297

Content-Type:	text/html; charset="utf-8"
Content-Transfer-Encoding:	7bit
X-RT-Original-Encoding:	utf-8
Content-Length:	1802

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

content-type:	application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; name="testing2.xlsx"
content-disposition:	attachment; filename="testing2.xlsx"
Content-Transfer-Encoding:	base64
Content-Length:	5724

testing2.xlsx

Message body not shown because it is not plain text.

content-type:	application/x-perl; name="libre_bug.pl"
content-disposition:	attachment; filename="libre_bug.pl"
Content-Transfer-Encoding:	7bit
Content-Length:	99

libre_bug.pl

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