Skip Menu |

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

Report information
The Basics
Id: 77849
Status: new
Priority: 0/
Queue: Spreadsheet-XLSX
People
Owner: Nobody in particular
Requestors: paul [...] walkerclan.us
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)
Attachments
dumpxls
example.tar
testcase.xlsx
XLSX.pm

History Show all quoted text
  Fri Jun 15 17:42:14 2012 paul [...] walkerclan.us - Ticket created
CC: "paul [...] walkerclan.us" <paul [...] walkerclan.us>
Subject: Problem with Spreadsheet::XLSX
Date: Fri, 15 Jun 2012 14:41:42 -0700
To: bug-Spreadsheet-XLSX [...] rt.cpan.org
From: paul [...] walkerclan.us
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$
Download example.tar
application/x-tar 10.5k

Message body not shown because it is not plain text.

  Thu Jun 28 20:45:46 2012 paul [...] walkerclan.us - Correspondence added
CC: "paul [...] walkerclan.us" <paul [...] walkerclan.us>
Subject: Re: [rt.cpan.org #77849] AutoReply: Problem with Spreadsheet::XLSX
Date: Thu, 28 Jun 2012 17:45:25 -0700
To: bug-Spreadsheet-XLSX [...] rt.cpan.org
From: paul [...] walkerclan.us
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$ > > >
Download dumpxls
application/octet-stream 1.2k

Message body not shown because it is not plain text.

Download testcase.xlsx
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet 9.4k

Message body not shown because it is not plain text.

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