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

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

People
Owner:
mikeb [...] cpan.org
Requestors:
eff.ess [...] web.de
Cc:
AdminCc:

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



From eff.ess@web.de Wed Jul 3 02: 23:28 2013
MIME-Version: 1.0
Sensitivity: Normal
X-Spam-Status: No, score=-6.175 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, MIME_HTML_ONLY=0.723, RCVD_IN_DNSWL_HI=-5] autolearn=ham
X-Spam-Flag: NO
X-Provags-ID: V03:K0:NXGaJdw59fEwkR8FOpHUOlgPQ98/FYQqcX5Upj+hhwO Flm5B4UGtmdQe5xDR2tAXG454Hew3UXj834X51rjdNOnCEdP4R +K2aRjDzAramvKC4W4G5jPfSmQfXdvWkMtAmYosw6hVEPwJrbr E2eBETxbQDZ42BB2cUS/F7QKT3K9FrS5V7BwJ6SqKqVCA//An0 xjC/FehkW07Sos6gTLgEkxvgYhx/HhnN+6cleMaRhZ0WYzRlcg tCsKsGkWyfP2K/bYrRKDbD5QfjVdTkoIQ9XQSt3tw3m95+IKIa jLK01MNeY0b+gS2Py1aC+06I6+l
X-Virus-Checked: Checked
Importance: normal
Content-Type: multipart/mixed; boundary="sgnirkm-c5304df7-bb10-402b-85d1-132cb4c7b911"
Message-ID: <trinity-c8caea80-f1c2-4ff0-9bd9-f2dc41806f4b-1372832592579@3capp-webde-bs06>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Spam-Score: -6.175
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id ACCFA240E7B for <cpan-bug+spreadsheet-xlsx@hipster.bestpractical.com>; Wed, 3 Jul 2013 02:23:28 -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 uT3+SGFHl15l for <cpan-bug+spreadsheet-xlsx@hipster.bestpractical.com>; Wed, 3 Jul 2013 02:23:27 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id ECF16240E66 for <bug-spreadsheet-xlsx@rt.cpan.org>; Wed, 3 Jul 2013 02:23:26 -0400 (EDT)
Received: (qmail 4563 invoked by alias); 3 Jul 2013 06:23:25 -0000
Received: from mout.web.de (HELO mout.web.de) (212.227.15.4) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Tue, 02 Jul 2013 23:23:19 -0700
Received: from 3capp-webde-bs06.server.lan ([172.19.170.6]) by mriweb.server.lan (mriweb002) with ESMTP (Nemesis) id 0MBoy1-1V3NI72q5n-00Ap1k for <bug-Spreadsheet-XLSX@rt.cpan.org>; Wed, 03 Jul 2013 08:23:12 +0200
Received: from [212.77.168.67] by 3capp-webde-bs06.server.lan with HTTP; Wed Jul 03 08:23:12 CEST 2013
Delivered-To: cpan-bug+spreadsheet-xlsx@hipster.bestpractical.com
Subject: Bug in parsing XLSX
Return-Path: <eff.ess@web.de>
X-Priority: 3
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, 3 Jul 2013 08:23:12 +0200 (CEST)
X-Spam-Level:
To: bug-Spreadsheet-XLSX@rt.cpan.org
From: "Felix Schnellinger" <eff.ess@web.de>
X-RT-Interface: Email
Content-Length: 0
content-type: text/html; charset="utf-8"
X-RT-Original-Encoding: utf-8
Content-Length: 2917
 
Hi there,
 
the attached spreadsheet produces errors when creating a new xlsx object
perl code:
my $excel = Spreadsheet::XLSX -> new ($infile);
 
output:
Argument "<f>" isn't numeric in int at /usr/local/share/perl/5.10.1/Spreadsheet/XLSX/Fmt2007.pm line 96.
 
I believe the following patch in XLSX.pm will solve the problem. Solution: When parsing the xlsx, check for closing AND EMPTY v-Tags before checking for opening v-tags
 
diff:
 
175a176,178
>                                            elsif (/^<\/v/ || /^<v\/>/) {
>                                                            $flag = 0;
>                                            }
178,180d180
<                                            }
<                                            elsif (/^<\/v/) {
<                                                            $flag = 0;
 
 
 
Please give me some feedback.
 
Best regards,
Felix Schnellinger
Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Content-Disposition: attachment; filename="test.xlsx"
Content-Transfer-Encoding: base64
Content-Length: 12714

Message body not shown because it is not plain text.



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.