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