Bug#298491: marked as done (libspreadsheet-parseexcel-perl: Superfluous spaces inserted in a cell)

Thu Dec 29 14:03:08 UTC 2005

Your message dated Thu, 29 Dec 2005 15:57:24 +0200
with message-id <20051229135722.GA478844 at sirppi.helsinki.fi>
and subject line Bug#298491: libspreadsheet-parseexcel-perl: Superfluous spaces inserted in a cell
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 21:12:17 +0000
>From fbriere at fbriere.net Mon Mar 07 13:12:16 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 1D8PWR-000822-00; Mon, 07 Mar 2005 13:12:16 -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 j27LBmSP025193
	for <submit at bugs.debian.org>; Mon, 7 Mar 2005 13:11:48 -0800 (PST)
	(envelope-from fbriere at fbriere.net)
Received: by toroia.hyrule.dyndns.org (Postfix, from userid 1000)
	id 79549BBCF; Mon,  7 Mar 2005 16:11:44 -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: Superfluous spaces inserted in a cell
X-Mailer: reportbug 3.8
Date: Mon, 07 Mar 2005 16:11:44 -0500
X-Debbugs-Cc: Kawai Takanori <kwitknr at cpan.org>
Message-Id: <20050307211144.79549BBCF 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

Here's another problematic mini-sheet:

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

Notice how the contents of the cell does not appear to contain any
spaces, according to both gnumeric and OOo.  However:

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

Changing the format of the cell to general seems to make it work again.

-- 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 298491-done) by bugs.debian.org; 29 Dec 2005 13:57:27 +0000
>From ntyni at cc.helsinki.fi Thu Dec 29 05:57:26 2005
Return-path: <ntyni at cc.helsinki.fi>
Received: from sirppi.helsinki.fi ([128.214.205.27])
	by spohr.debian.org with esmtp (Exim 4.50)
	id 1EryHW-0001H1-I6
	for 298491-done at bugs.debian.org; Thu, 29 Dec 2005 05:57:26 -0800
Received: from sirppi.helsinki.fi (localhost [127.0.0.1])
	by sirppi.helsinki.fi (8.13.2/8.13.2) with ESMTP id jBTDvOfp500985
	for <298491-done at bugs.debian.org>; Thu, 29 Dec 2005 15:57:24 +0200 (EET)
Received: (from ntyni at localhost)
	by sirppi.helsinki.fi (8.13.2/8.13.2/Submit) id jBTDvOVc325002
	for 298491-done at bugs.debian.org; Thu, 29 Dec 2005 15:57:24 +0200 (EET)
Date: Thu, 29 Dec 2005 15:57:24 +0200
From: Niko Tyni <ntyni at iki.fi>
To: 298491-done at bugs.debian.org
Subject: Re: Bug#298491: libspreadsheet-parseexcel-perl: Superfluous spaces inserted in a cell
Message-ID: <20051229135722.GA478844 at sirppi.helsinki.fi>
References: <20050307211144.79549BBCF at toroia.hyrule.dyndns.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20050307211144.79549BBCF at toroia.hyrule.dyndns.org>
User-Agent: Mutt/1.4.2i
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

> Notice how the contents of the cell does not appear to contain any
> spaces, according to both gnumeric and OOo.  However:
> 
>   [fbriere] toroia:/home/imars/gx $ perl -MSpreadsheet::ParseExcel -le 'print "<", Spreadsheet::ParseExcel->new->Parse("spaces.xls")->{Worksheet}[0]{Cells}[0][0]->Value, ">"'
>   < 1-119 >
> 
> Changing the format of the cell to general seems to make it work again.

Hi,

this is not a bug, but documented behaviour. The Value() method returns
the formatted value of the cell. The cell format includes whitespace
(denoted by the format code '_', ie. an underscore).

If you want the unformatted value, use the {Val} "property":

% perl -MSpreadsheet::ParseExcel -le 'print "<", Spreadsheet::ParseExcel->new->Parse("spaces.xls")->{Worksheet}[0]{Cells}[0][0]->{Val}, ">"'
<1-119>

I'm closing this bug.

Cheers,
-- 
Niko Tyni	ntyni at iki.fi