Bug#298484: marked as done (libspreadsheet-parseexcel-perl: Some cells return "GENERAL" instead of value)

Mon Jan 2 18:03:19 UTC 2006

Your message dated Mon, 02 Jan 2006 09:47:06 -0800
with message-id <E1EtTly-0000j4-Mt at spohr.debian.org>
and subject line Bug#298484: fixed in libspreadsheet-parseexcel-perl 0.2603-4
has caused the attached Bug report to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere.  Please contact me immediately.)

Debian bug tracking system administrator
(administrator, Debian Bugs database)

--------------------------------------
Received: (at submit) by bugs.debian.org; 7 Mar 2005 20:20:33 +0000
>From fbriere at fbriere.net Mon Mar 07 12:20:33 2005
Return-path: <fbriere at fbriere.net>
Received: from smtp.imars.net [64.62.144.114] 
	by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
	id 1D8OiP-0003BG-00; Mon, 07 Mar 2005 12:20:33 -0800
Received: from toroia.hyrule.dyndns.org (modemcable252.255-80-70.mc.videotron.ca [70.80.255.252])
	by smtp.imars.net (8.12.11/8.12.11) with ESMTP id j27KK56T022925
	for <submit at bugs.debian.org>; Mon, 7 Mar 2005 12:20:06 -0800 (PST)
	(envelope-from fbriere at fbriere.net)
Received: by toroia.hyrule.dyndns.org (Postfix, from userid 1000)
	id 2D3ADBBEB; Mon,  7 Mar 2005 15:20:01 -0500 (EST)
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Frederic Briere <fbriere at fbriere.net>
To: Debian Bug Tracking System <submit at bugs.debian.org>
Subject: libspreadsheet-parseexcel-perl: Some cells return "GENERAL" instead of value
X-Mailer: reportbug 3.8
Date: Mon, 07 Mar 2005 15:20:01 -0500
X-Debbugs-Cc: Kawai Takanori <kwitknr at cpan.org>
Message-Id: <20050307202001.2D3ADBBEB at toroia.hyrule.dyndns.org>
Delivered-To: submit at bugs.debian.org
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 
	(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-11.0 required=4.0 tests=BAYES_00,HAS_PACKAGE,
	X_DEBBUGS_CC autolearn=ham version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level: 

Package: libspreadsheet-parseexcel-perl
Version: 0.2603-2
Severity: normal

I refer you to the following spreadsheet:

<http://www.imars.com/~fbriere/general.xls>

Cell A1 of this sheet has contents of 1210.  But for some reason, Ss::PE
returns "GENERAL" for it instead:

  [fbriere] toroia:/home/imars/gx $ perl -MSpreadsheet::ParseExcel -le 'print Spreadsheet::ParseExcel->new->Parse("general.xls")->{Worksheet}[0]{Cells}[0][0]->Value' 
  GENERAL

This bug appeared when we switched from Excel to OOo; it happens
arbitrarily, and I haven't been able to find a pattern for its
occurrence.  Changing the format of a cell from general to text seems to
prevent this problem.

-- System Information:
Debian Release: 3.1
  APT prefers unstable
  APT policy: (500, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.10
Locale: LANG=en_CA, LC_CTYPE=en_CA (charmap=ISO-8859-1)

Versions of packages libspreadsheet-parseexcel-perl depends on:
ii  libole-storage-lite-perl      0.14-2     simple class for OLE document inte
ii  perl                          5.8.4-6    Larry Wall's Practical Extraction 

-- no debconf information

---------------------------------------
Received: (at 298484-close) by bugs.debian.org; 2 Jan 2006 17:50:42 +0000
>From katie at ftp-master.debian.org Mon Jan 02 09:50:41 2006
Return-path: <katie at ftp-master.debian.org>
Received: from katie by spohr.debian.org with local (Exim 4.50)
	id 1EtTly-0000j4-Mt; Mon, 02 Jan 2006 09:47:06 -0800
From: Gunnar Wolf <gwolf at debian.org>
To: 298484-close at bugs.debian.org
X-Katie: $Revision: 1.65 $
Subject: Bug#298484: fixed in libspreadsheet-parseexcel-perl 0.2603-4
Message-Id: <E1EtTly-0000j4-Mt at spohr.debian.org>
Sender: Archive Administrator <katie at ftp-master.debian.org>
Date: Mon, 02 Jan 2006 09:47:06 -0800
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 
	(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level: 
X-Spam-Status: No, hits=-6.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER 
	autolearn=no version=2.60-bugs.debian.org_2005_01_02

Source: libspreadsheet-parseexcel-perl
Source-Version: 0.2603-4

We believe that the bug you reported is fixed in the latest version of
libspreadsheet-parseexcel-perl, which is due to be installed in the Debian FTP archive:

libspreadsheet-parseexcel-perl_0.2603-4.diff.gz
  to pool/main/libs/libspreadsheet-parseexcel-perl/libspreadsheet-parseexcel-perl_0.2603-4.diff.gz
libspreadsheet-parseexcel-perl_0.2603-4.dsc
  to pool/main/libs/libspreadsheet-parseexcel-perl/libspreadsheet-parseexcel-perl_0.2603-4.dsc
libspreadsheet-parseexcel-perl_0.2603-4_all.deb
  to pool/main/libs/libspreadsheet-parseexcel-perl/libspreadsheet-parseexcel-perl_0.2603-4_all.deb

A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to 298484 at bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Gunnar Wolf <gwolf at debian.org> (supplier of updated libspreadsheet-parseexcel-perl package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmaster at debian.org)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Format: 1.7
Date: Mon,  2 Jan 2006 11:28:39 -0600
Source: libspreadsheet-parseexcel-perl
Binary: libspreadsheet-parseexcel-perl
Architecture: source all
Version: 0.2603-4
Distribution: unstable
Urgency: low
Maintainer: Debian Perl Group <pkg-perl-maintainers at lists.alioth.debian.org>
Changed-By: Gunnar Wolf <gwolf at debian.org>
Description: 
 libspreadsheet-parseexcel-perl - access information from Excel Spreadsheets
Closes: 298484
Changes: 
 libspreadsheet-parseexcel-perl (0.2603-4) unstable; urgency=low
 .
   * No longer reports "GENERAL" instead of the actual value in files
     created by OpenOffice - Thanks Niko Tyni for the patch! (Closes:
     #298484)
   * Updated standards-version to 3.6.2
   * Updated debhelper dependency to 4
Files: 
 3d5f318c097741eeed397392cc3a2541 760 perl optional libspreadsheet-parseexcel-perl_0.2603-4.dsc
 4a223c67a4823df609de18d3d0c5819d 3445 perl optional libspreadsheet-parseexcel-perl_0.2603-4.diff.gz
 119e5cb41b18df55f723837b341945b8 118578 perl optional libspreadsheet-parseexcel-perl_0.2603-4_all.deb

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)

iD8DBQFDuWL22A7zWou1J68RAkVoAJsFAGKejnGX25a0DvG8EbS5eSXYTACfXYW6
nIkP8s+yjGJzVVuyEhJWo0U=
=tNWw
-----END PGP SIGNATURE-----