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