Bug#298484: libspreadsheet-parseexcel-perl: Some cells return "GENERAL" instead of value

Frederic Briere Frederic Briere <fbriere@fbriere.net>, 298484@bugs.debian.org
Mon, 07 Mar 2005 15:20:01 -0500


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