Skip Menu |
 
rt.cpan.org will be shut down on March 1st, 2021.

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)



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
Download (untitled) / with headers
text/plain 3.7k
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.

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
Download (untitled) / with headers
text/plain 5.9k
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.

Download XLSX.pm
text/x-perl 9.4k

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



This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.