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

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

People
Owner:
Nobody in particular
Requestors:
paul [...] walkerclan.us
Cc:
AdminCc:



From paul@walkerclan.us Fri Jun 15 17: 42:13 2012
CC: "paul@walkerclan.us" <paul@walkerclan.us>
MIME-Version: 1.0
X-Spam-Status: No, score=-6.9 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5] autolearn=ham
X-Spam-Flag: NO
X-Virus-Checked: Checked by ClamAV on 16.mx.develooper.com
Importance: Normal
Content-Type: multipart/mixed;boundary="----=_20120615144142_74085"
Message-ID: <5266fac65ee73030938615046eaf3ca1.squirrel@www.walkerclan.us>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Virus-Scanned: amavisd-new at walkerclan.us
X-Spam-Score: -6.9
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 8C7662403D1 for <cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com>; Fri, 15 Jun 2012 17:42:13 -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 u9omOeI3b+rg for <cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com>; Fri, 15 Jun 2012 17:42:10 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 5641824037F for <bug-Spreadsheet-XLSX@rt.cpan.org>; Fri, 15 Jun 2012 17:42:09 -0400 (EDT)
Received: (qmail 6675 invoked by uid 103); 15 Jun 2012 21:42:09 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 15 Jun 2012 21:42:09 -0000
Received: from www.macaroon.walkerclan.us (HELO mail.walkerclan.us) (98.173.58.2) by 16.mx.develooper.com (qpsmtpd/0.80/v0.80-19-gf52d165) with ESMTP; Fri, 15 Jun 2012 14:42:05 -0700
Received: from localhost (localhost [127.0.0.1]) by mail.walkerclan.us (Postfix) with ESMTP id F2A25995EA7; Fri, 15 Jun 2012 14:42:01 -0700 (PDT)
Received: from mail.walkerclan.us ([127.0.0.1]) by localhost (macaroon.twinoaks.walkerclan.us [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 2vf1Jr91RZ22; Fri, 15 Jun 2012 14:41:42 -0700 (PDT)
Received: from www.walkerclan.us (localhost [127.0.0.1]) by mail.walkerclan.us (Postfix) with ESMTP id 81C8F995E77; Fri, 15 Jun 2012 14:41:42 -0700 (PDT)
Received: from 108.225.233.221 (SquirrelMail authenticated user paul) by www.walkerclan.us with HTTP; Fri, 15 Jun 2012 14:41:42 -0700
X-Amavis-Hold: Exceeded storage quota 10454500 bytes by do_pax_cpio/pre; last chunk 8589943004 bytes
Delivered-To: cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com
User-Agent: SquirrelMail/1.4.20
Subject: Problem with Spreadsheet::XLSX
Return-Path: <paul@walkerclan.us>
X-Priority: 3 (Normal)
X-RT-Mail-Extension: spreadsheet-xlsx
X-Original-To: cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com
X-Spam-Check-BY: 16.mx.develooper.com
Date: Fri, 15 Jun 2012 14:41:42 -0700
X-Spam-Level:
To: bug-Spreadsheet-XLSX@rt.cpan.org
From: paul@walkerclan.us
Content-Length: 0
content-type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 8bit
X-RT-Original-Encoding: iso-8859-1
Content-Length: 3830
I am having a problem with Spreadsheet::XLSX, version 0.13, loaded from cpan.org. The attached tar file contains a perl script and a sample spreadsheet. The script should dump the contents of the sheets, and it does work on other spreadsheets, but not this one. I can open the spreadsheet with OpenOffice, and can manipulate it too, so I don't think the spreadsheet is corrupted. Here is sample output from running the script:
Show quoted text
---------- Begin ----------- epsilon:WPOSupport paul$ ./dumpxls EditedSettlement.xlsx epsilon:WPOSupport paul$ ----------- End ----------- There should have been much more output. Here is output from perl -V: epsilon:WPOSupport paul$ perl -V Summary of my perl5 (revision 5 version 10 subversion 0) configuration: Platform: osname=darwin, osvers=10.0, archname=darwin-thread-multi-2level uname='darwin pizzly.apple.com 10.0 darwin kernel version 10.0.0: fri jul 31 22:46:25 pdt 2009; root:xnu-1456.1.25~1release_x86_64 x86_64 ' config_args='-ds -e -Dprefix=/usr -Dccflags=-g -pipe -Dldflags= -Dman3ext=3pm -Duseithreads -Duseshrplib -Dinc_version_list=none -Dcc=gcc-4.2' hint=recommended, useposix=true, d_sigaction=define useithreads=define, usemultiplicity=define useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef use64bitint=define, use64bitall=define, uselongdouble=undef usemymalloc=n, bincompat5005=undef Compiler: cc='gcc-4.2', ccflags ='-arch x86_64 -arch i386 -arch ppc -g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing -I/usr/local/include', optimize='-Os', cppflags='-g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing -I/usr/local/include' ccversion='', gccversion='4.2.1 (Apple Inc. build 5646)', gccosandvers='' intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=8, prototype=define Linker and Libraries: ld='gcc-4.2 -mmacosx-version-min=10.6.3', ldflags ='-arch x86_64 -arch i386 -arch ppc -L/usr/local/lib' libpth=/usr/local/lib /usr/lib libs=-ldbm -ldl -lm -lutil -lc perllibs=-ldl -lm -lutil -lc libc=/usr/lib/libc.dylib, so=dylib, useshrplib=true, libperl=libperl.dylib gnulibc_version='' Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=bundle, d_dlsymun=undef, ccdlflags=' ' cccdlflags=' ', lddlflags='-arch x86_64 -arch i386 -arch ppc -bundle -undefined dynamic_lookup -L/usr/local/lib' Characteristics of this binary (from libperl): Compile-time options: MULTIPLICITY PERL_DONT_CREATE_GVSV PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP USE_64_BIT_ALL USE_64_BIT_INT USE_ITHREADS USE_LARGE_FILES USE_PERLIO USE_REENTRANT_API Locally applied patches: /Library/Perl/Updates/<version> comes before system perl directories installprivlib and installarchlib points to the Updates directory Built under darwin Compiled at Jan 26 2010 17:48:53 @INC: /Library/Perl/Updates/5.10.0/darwin-thread-multi-2level /Library/Perl/Updates/5.10.0 /System/Library/Perl/5.10.0/darwin-thread-multi-2level /System/Library/Perl/5.10.0 /Library/Perl/5.10.0/darwin-thread-multi-2level /Library/Perl/5.10.0 /Network/Library/Perl/5.10.0/darwin-thread-multi-2level /Network/Library/Perl/5.10.0 /Network/Library/Perl /System/Library/Perl/Extras/5.10.0/darwin-thread-multi-2level /System/Library/Perl/Extras/5.10.0 . epsilon:WPOSupport paul$ OS Vendor and version: epsilon:WPOSupport paul$ uname -a Darwin epsilon.northsandiegomath.com 10.8.0 Darwin Kernel Version 10.8.0: Tue Jun 7 16:32:41 PDT 2011; root:xnu-1504.15.3~1/RELEASE_X86_64 x86_64 epsilon:WPOSupport paul$
content-type: application/x-tar; name="example.tar"
content-disposition: attachment; filename="example.tar"
Content-Transfer-Encoding: base64
Content-Length: 10752

Message body not shown because it is not plain text.

From paul@walkerclan.us Thu Jun 28 20: 45:45 2012
CC: "paul@walkerclan.us" <paul@walkerclan.us>
MIME-Version: 1.0
X-Spam-Status: No, score=-4.776 tagged_above=-99.9 required=10 tests=[AWL=2.123, BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5, TO_NO_BRKTS_PCNT=0.001] autolearn=ham
In-Reply-To: <rt-3.8.HEAD-1296-1339796535-868.77849-3-0@rt.cpan.org>
X-Spam-Flag: NO
References: <RT-Ticket-77849@rt.cpan.org> <5266fac65ee73030938615046eaf3ca1.squirrel@www.walkerclan.us> <rt-3.8.HEAD-1296-1339796535-868.77849-3-0@rt.cpan.org>
Importance: Normal
X-Virus-Checked: Checked by ClamAV on 16.mx.develooper.com
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Virus-Scanned: amavisd-new at walkerclan.us
Message-ID: <1b7720036f0fbb510be6b60aca6908ed.squirrel@www.walkerclan.us>
Content-Type: multipart/mixed;boundary="----=_20120628174524_57401"
X-Spam-Score: -4.776
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 927E2240414 for <cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com>; Thu, 28 Jun 2012 20:45:45 -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 BxHHM91RrJyT for <cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com>; Thu, 28 Jun 2012 20:45:42 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 9611A2403C6 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Thu, 28 Jun 2012 20:45:38 -0400 (EDT)
Received: (qmail 29684 invoked by uid 103); 29 Jun 2012 00:45:37 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 29 Jun 2012 00:45:37 -0000
Received: from www.macaroon.walkerclan.us (HELO mail.walkerclan.us) (98.173.58.2) by 16.mx.develooper.com (qpsmtpd/0.80/v0.80-19-gf52d165) with ESMTP; Thu, 28 Jun 2012 17:45:30 -0700
Received: from localhost (localhost [127.0.0.1]) by mail.walkerclan.us (Postfix) with ESMTP id 835859A51E0; Thu, 28 Jun 2012 17:45:27 -0700 (PDT)
Received: from mail.walkerclan.us ([127.0.0.1]) by localhost (macaroon.twinoaks.walkerclan.us [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id EEoEWnzWy0im; Thu, 28 Jun 2012 17:45:25 -0700 (PDT)
Received: from www.walkerclan.us (localhost [127.0.0.1]) by mail.walkerclan.us (Postfix) with ESMTP id 875AF9A51B7; Thu, 28 Jun 2012 17:45:24 -0700 (PDT)
Received: from 108.225.233.221 (SquirrelMail authenticated user paul) by www.walkerclan.us with HTTP; Thu, 28 Jun 2012 17:45:25 -0700
Delivered-To: cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com
Subject: Re: [rt.cpan.org #77849] AutoReply: Problem with Spreadsheet::XLSX
User-Agent: SquirrelMail/1.4.20
Return-Path: <paul@walkerclan.us>
X-Spam-Check-BY: 16.mx.develooper.com
X-Original-To: cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com
X-RT-Mail-Extension: spreadsheet-xlsx
X-Priority: 3 (Normal)
Date: Thu, 28 Jun 2012 17:45:25 -0700
X-Spam-Level:
To: bug-Spreadsheet-XLSX@rt.cpan.org
From: paul@walkerclan.us
RT-Message-ID: <rt-3.8.HEAD-20677-1340930746-1589.77849-0-0@rt.cpan.org>
Content-Length: 0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 8bit
X-RT-Original-Encoding: utf-8
Content-Length: 6068
It turns out that the test program and testcase were both defective. I have attached a corrected test program, as well as a proper testcase. I have also included a patched version of XLSX.pm that properly parses the spreadsheet. My solution is not elegant, but it works. I don't think it is a general solution, but it works :-) Here are example runs with dumpxls edited to use the original and patched version of the libary.
Show quoted text
------ Original ------ Newton:xlsx_work tpl$ ./dumpxls testcase.xlsx Dumping workbook 'testcase.xlsx' End of workbook 'testcase.xlsx' --------------------
------ Patched ------ Newton:xlsx_work tpl$ ./dumpxls testcase.xlsx Dumping workbook 'testcase.xlsx' Dumping sheet SettlementReport (1,1) => Daily Settlement Report (2,1) => Merchant (3,1) => Payer's Name (3,2) => Amount (3,3) => Confirmation # (3,4) => Last4 CC (3,5) => Card Type (3,6) => Payment Date (3,7) => Class (4,1) => Fred Phinklemeier (4,2) => 123 (4,3) => 123456 (4,4) => 1423 (4,5) => Myob (4,6) => 40059.89166667 (4,7) => Seattle (5,1) => Total (5,2) => 123 End of sheet Dumping sheet Failed Payments End of sheet End of workbook 'testcase.xlsx' Newton:xlsx_work tpl$ -------------------- Paul
> > Greetings, > > This message has been automatically generated in response to the > creation of a trouble ticket regarding: > "Problem with Spreadsheet::XLSX", > a summary of which appears below. > > There is no need to reply to this message right now. Your ticket has been > assigned an ID of [rt.cpan.org #77849]. Your ticket is accessible > on the web at: > > https://rt.cpan.org/Ticket/Display.html?id=77849 > > Please include the string: > > [rt.cpan.org #77849] > > in the subject line of all future correspondence about this issue. To do > so, > you may reply to this message. > > Thank you, > bug-Spreadsheet-XLSX@rt.cpan.org > > ------------------------------------------------------------------------- > I am having a problem with Spreadsheet::XLSX, version 0.13, loaded from > cpan.org. > > The attached tar file contains a perl script and a sample spreadsheet. > The script should dump the contents of the sheets, and it does work on > other spreadsheets, but not this one. I can open the spreadsheet with > OpenOffice, and can manipulate it too, so I don't think the spreadsheet is > corrupted. > > Here is sample output from running the script: > ---------- Begin ----------- > epsilon:WPOSupport paul$ ./dumpxls EditedSettlement.xlsx > epsilon:WPOSupport paul$ > ----------- End ----------- > There should have been much more output. > > > Here is output from perl -V: > > epsilon:WPOSupport paul$ perl -V > Summary of my perl5 (revision 5 version 10 subversion 0) configuration: > Platform: > osname=darwin, osvers=10.0, archname=darwin-thread-multi-2level > uname='darwin pizzly.apple.com 10.0 darwin kernel version 10.0.0: fri > jul 31 22:46:25 pdt 2009; root:xnu-1456.1.25~1release_x86_64 x86_64 ' > config_args='-ds -e -Dprefix=/usr -Dccflags=-g -pipe -Dldflags= > -Dman3ext=3pm -Duseithreads -Duseshrplib -Dinc_version_list=none > -Dcc=gcc-4.2' > hint=recommended, useposix=true, d_sigaction=define > useithreads=define, usemultiplicity=define > useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef > use64bitint=define, use64bitall=define, uselongdouble=undef > usemymalloc=n, bincompat5005=undef > Compiler: > cc='gcc-4.2', ccflags ='-arch x86_64 -arch i386 -arch ppc -g -pipe > -fno-common -DPERL_DARWIN -fno-strict-aliasing -I/usr/local/include', > optimize='-Os', > cppflags='-g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing > -I/usr/local/include' > ccversion='', gccversion='4.2.1 (Apple Inc. build 5646)', > gccosandvers='' > intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678 > d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 > ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', > lseeksize=8 > alignbytes=8, prototype=define > Linker and Libraries: > ld='gcc-4.2 -mmacosx-version-min=10.6.3', ldflags ='-arch x86_64 -arch > i386 -arch ppc -L/usr/local/lib' > libpth=/usr/local/lib /usr/lib > libs=-ldbm -ldl -lm -lutil -lc > perllibs=-ldl -lm -lutil -lc > libc=/usr/lib/libc.dylib, so=dylib, useshrplib=true, > libperl=libperl.dylib > gnulibc_version='' > Dynamic Linking: > dlsrc=dl_dlopen.xs, dlext=bundle, d_dlsymun=undef, ccdlflags=' ' > cccdlflags=' ', lddlflags='-arch x86_64 -arch i386 -arch ppc -bundle > -undefined dynamic_lookup -L/usr/local/lib' > > > Characteristics of this binary (from libperl): > Compile-time options: MULTIPLICITY PERL_DONT_CREATE_GVSV > PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP > USE_64_BIT_ALL > USE_64_BIT_INT USE_ITHREADS USE_LARGE_FILES > USE_PERLIO USE_REENTRANT_API > Locally applied patches: > /Library/Perl/Updates/<version> comes before system perl directories > installprivlib and installarchlib points to the Updates directory > Built under darwin > Compiled at Jan 26 2010 17:48:53 > @INC: > /Library/Perl/Updates/5.10.0/darwin-thread-multi-2level > /Library/Perl/Updates/5.10.0 > /System/Library/Perl/5.10.0/darwin-thread-multi-2level > /System/Library/Perl/5.10.0 > /Library/Perl/5.10.0/darwin-thread-multi-2level > /Library/Perl/5.10.0 > /Network/Library/Perl/5.10.0/darwin-thread-multi-2level > /Network/Library/Perl/5.10.0 > /Network/Library/Perl > /System/Library/Perl/Extras/5.10.0/darwin-thread-multi-2level > /System/Library/Perl/Extras/5.10.0 > . > epsilon:WPOSupport paul$ > > > > OS Vendor and version: > > epsilon:WPOSupport paul$ uname -a > Darwin epsilon.northsandiegomath.com 10.8.0 Darwin Kernel Version 10.8.0: > Tue Jun 7 16:32:41 PDT 2011; root:xnu-1504.15.3~1/RELEASE_X86_64 x86_64 > epsilon:WPOSupport paul$ > > >
content-type: application/octet-stream; name="dumpxls"
content-disposition: attachment; filename="dumpxls"
Content-Transfer-Encoding: base64
Content-Length: 1288

Message body not shown because it is not plain text.

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

Message body not shown because it is not plain text.

content-type: text/x-perl-script; name="XLSX.pm"
content-disposition: attachment; filename="XLSX.pm"
Content-Transfer-Encoding: 8bit
Content-Length: 9634

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.