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

Report information
The Basics
Id:
86667
Status:
open
Priority:
Low/Low

People
Owner:
mikeb [...] cpan.org
Requestors:
negor [...] at.ua
Cc:
AdminCc:

BugTracker
Severity:
(no value)
Broken in:
(no value)
Fixed in:
(no value)



From negor@at.ua Wed Jul 3 03: 35:17 2013
MIME-Version: 1.0
X-Spam-Status: No, score=-4.652 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, FSL_HELO_BARE_IP_2=2.248, RCVD_IN_DNSWL_HI=-5] autolearn=ham
X-Spam-Flag: NO
content-type: text/plain; charset="utf-8"; format="flowed"
Message-ID: <51D3D41C.9040108@at.ua>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Spam-Score: -4.652
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 088BE240E5F for <cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com>; Wed, 3 Jul 2013 03:35:17 -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 rpxazkdyYL1F for <cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com>; Wed, 3 Jul 2013 03:35:15 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 6B847240DBC for <bug-Spreadsheet-XLSX@rt.cpan.org>; Wed, 3 Jul 2013 03:35:14 -0400 (EDT)
Received: (qmail 9082 invoked by alias); 3 Jul 2013 07:35:14 -0000
Received: from forward2h.mail.yandex.net (HELO forward2h.mail.yandex.net) (84.201.187.147) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Wed, 03 Jul 2013 00:35:02 -0700
Received: from smtp3h.mail.yandex.net (smtp3h.mail.yandex.net [84.201.186.20]) by forward2h.mail.yandex.net (Yandex) with ESMTP id 8DCEA701C37 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Wed, 3 Jul 2013 11:34:56 +0400 (MSK)
Received: from smtp3h.mail.yandex.net (localhost [127.0.0.1]) by smtp3h.mail.yandex.net (Yandex) with ESMTP id 641231B40062 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Wed, 3 Jul 2013 11:34:56 +0400 (MSK)
Received: from 109.122.62.126.static.uch.net (109.122.62.126.static.uch.net [109.122.62.126]) by smtp3h.mail.yandex.net (nwsmtp/Yandex) with ESMTP id cOZ2rYXtpA-YtSqL1Lx; Wed, 3 Jul 2013 11:34:55 +0400
Delivered-To: cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com
Subject: Something wrong with xlsx generated by Google
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130620 Thunderbird/17.0.7
Return-Path: <negor@at.ua>
X-RT-Mail-Extension: spreadsheet-xlsx
X-Original-To: cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com
X-Spam-Check-BY: la.mx.develooper.com
Date: Wed, 03 Jul 2013 10:34:52 +0300
X-Spam-Level:
To: bug-Spreadsheet-XLSX@rt.cpan.org
Content-Transfer-Encoding: 8bit
From: Negor <negor@at.ua>
X-RT-Original-Encoding: utf-8
X-RT-Interface: Email
Content-Length: 1163
So, when I try to parse xlsx from google my %excel = %{Spreadsheet::XLSX -> new ($file)}; print Dumper(\%excel); I get this Use of uninitialized value in concatenation (.) or string at D:/usr/site/lib/Spreadsheet/XLSX.pm line 150. $VAR1 = bless( { 'Worksheet' => [ bless( { 'DefColWidth' => '8.43', 'MinCol' => 1000000, 'MaxRow' => 0, 'MinRow' => 1000000, 'path' => undef, 'MaxCol' => 0, 'Name' => '╦шёЄ1', 'Cells' => undef }, 'Spreadsheet::ParseExcel::Worksheet' ) ], 'Flg1904' => 0, 'FmtClass' => bless( {}, 'Spreadsheet::XLSX::Fmt2007' ), 'SheetCount' => 1 }, 'Spreadsheet::ParseExcel::Workbook' );
MIME-Version: 1.0
In-Reply-To: <51D3D41C.9040108@at.ua>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: API
References: <51D3D41C.9040108@at.ua>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-12907-1399005581-505.0-0-0@rt.cpan.org>
Message-ID: <rt-4.0.18-12907-1399005581-384.86667-0-0@rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
From: rlauer6@comcast.net
Content-Length: 888
Stumbled on this one too...appears to be some incorrect parsing of the rels file. The parser is looking for a very specific ordering of the attributes, however they are not in the order that the parser is expecting. The fix below works for me...a better approach might be to split the attributes on white space and grep for the attributes but I suspect the author was looking for speed in processing columns of a spreadsheet. foreach ($member_rels -> contents =~ /\<Relationship (.*?)\/?\>/g) { #/^Id="(.*?)".*?Target="(.*?)"/ or next; if (/^Id="(.*?)".*?Target="(.*?)"/) { $rels {$1} = $2; } elsif (/^Type=".*?".*?Target="\/xl\/(.*?)".*?Id="(.*?)"/) { $rels {$2} = $1; } elsif (/^Target="\/xl\/(.*?)".*?Type=".*?".*?Id="(.*?)"/) { $rels {$2} = $1; } elsif (/^Target="(.*?)".*?Type=".*?".*?Id="(.*?)"/) { $rels {$2} = $1; } }
MIME-Version: 1.0
In-Reply-To: <rt-4.0.18-12907-1399005581-505.0-0-0@rt.cpan.org>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: API
References: <51D3D41C.9040108@at.ua> <rt-4.0.18-12907-1399005581-505.0-0-0@rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-24554-1399005801-271.0-0-0@rt.cpan.org>
Message-ID: <rt-4.0.18-24554-1399005801-1682.86667-0-0@rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
From: rlauer6@comcast.net
Content-Length: 327
Also will need this fix for the Google downloaded .xlsx files - again the parser was looking for the r= attribute immediately after the tag open which is not always the case... foreach ($member_sheet -> contents =~ /(\<.*?\/?\>|.*?(?=\<))/g) { if (/^\<c\s*.*?\s*r=\"([A-Z])([A-Z]?)(\d+)\"/) { $col = ord ($1) - 65;


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.