Skip Menu | You are currently an anonymous guest. | Login | Return to Main | About rt.cpan.org
 

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

X Report information
Id: 35678
Status: resolved
Left: 0 min
Priority: 0/0
Queue: Spreadsheet-ParseExcel

Owner: Nobody
Requestors: svar1 <moka [...] hol.gr>
Cc:
AdminCc:

Severity: Important
Broken in: 0.32
Fixed in: (no value)




X History Display mode: Brief headersFull headers
#   Wed May 07 02:43:02 2008 svar1 - Ticket created  
Subject: Spreadsheet::ParseExcel crash on big entries or non-english characters?
[text/plain 17.7k]
Message body not shown because it is too large or is not plain text.
Subject: newprs.pl

[text/plain 1.1k]
#instructions: run with perl newprs.pl test.xls
# you should get a substr outside of string error
# now open the excel file, go to the entry in the notes collumn, line 2 and just get
# rid of the first character(a greek terminal s) , the one before the :
#run again and behold! it runs fine

# Bug reproduced with perl v5.8.7(activestate build 815), also same on linux
#


#!/usr/bin/perl -w

use Spreadsheet::ParseExcel;

use strict;

my $filename = shift || "test.xls";

my $e = new Spreadsheet::ParseExcel;
my $eBook = $e->Parse($filename);

my $sheets = $eBook->{SheetCount};
my ($eSheet, $sheetName);

foreach my $sheet (0 .. $sheets - 1) {
$eSheet = $eBook->{Worksheet}[$sheet];
$sheetName = $eSheet->{Name};
print "Worksheet $sheet: $sheetName\n";
next unless (exists ($eSheet->{MaxRow}) and
(exists ($eSheet->{MaxCol})));
foreach my $row ($eSheet->{MinRow} .. $eSheet->{MaxRow}) {
foreach my $column ($eSheet->{MinCol} .. $eSheet->{MaxCol}) {
next unless (defined $eSheet->{Cells}[$row][$column]);
print $eSheet->{Cells}[$row][$column]->Value . " ";
}
print "\n";
}
}
Subject: test.xls

[application/vnd.ms-excel 32k]
Message body not shown because it is too large or is not plain text.
Subject: test1.xls

[application/vnd.ms-excel 13.5k]
Message body not shown because it is too large or is not plain text.
#   Thu Jan 08 07:42:09 2009 JMCNAMARA - Correspondence added  
[text/plain 92b]

Same as https://rt.cpan.org/Ticket/Display.html?id=41813

I'm looking into it.

John.
--


#   Thu Jan 08 07:42:09 2009 RT_System - Status changed from 'new' to 'open'  
#   Wed Jan 14 03:57:00 2009 JMCNAMARA - Correspondence added  
[text/plain 94b]

Hi,

This issue has been fixed in Spreadsheet::ParseExcel version 0.45.

Thanks,

John.
--


#   Wed Jan 14 03:57:02 2009 JMCNAMARA - Status changed from 'open' to 'resolved'