Bug#298491: libspreadsheet-parseexcel-perl: Superfluous spaces inserted in a cell

Frederic Briere Frederic Briere <fbriere@fbriere.net>, 298491@bugs.debian.org
Mon, 07 Mar 2005 16:11:44 -0500


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