#390777 xls2csv (catdoc) drops columns from last row

Package:
catdoc
Source:
catdoc
Description:
text extractor for MS-Office files
Submitter:
Derek Douville
Date:
2015-12-23 21:27:04 UTC
Severity:
normal
#390777#5
Date:
2006-10-03 00:20:04 UTC
From:
To:
SYNOPSIS
   xls2csv drops columns from the last row in the following circumstance.
The last row has no data in the last several columns, but catdoc incorrectly
counts 10 columns (in my example) as opposed to 12.

SAMPLE DATA
This is sample data generated from a Microsoft Excel 2003 SP2 by running
xls2csv <filename>:

OAU_TC87","Validate that a user can be searched successfully using the emailAddress attribute of the User class",,,"*","1","class.User","search","query:emailAddress=-dave@example.com-","RunTimeRef","NONE","I"
"OAU_TS1","OAU_TC88","Validate that the User returned by the previous search can be deleted successfully",,,"*","1","RunTimeRef","delete","NONE","0","NONE","I"
"OAU_TS1","OAU_TC89","Validate that a user cannot be found after deletion",,,"*","1","class.User","search","query:emailAddress=-dave@example.com-","NONE","NONE","I"
"OAU_TS1","OAU_TC90","tear down",,,"obapi.tear_down()","1",,,,
(^L == workbook delimeter here)

Note how the data above is missing 2 columns in the final row.  I have tested
this by both redirecting to file and to pty with identical results.   It is
important to know that in the Excel file, the two missing columns are also
empty, and I was expecting two more blank columns here.

ENVIRONMENT
  Linux poutine 2.6.12-9-386 #1 Mon Oct 10 13:14:36 BST 2005 i686 GNU/Linux
  IBM Thinkpad T40
  I recompiled the 0.94.2-1 debian package from source to validate that this
bug hasn't been fixed even in source.
  poutine::/home/derek$ dpkg -s libc6 | grep ^Version
  Version: 2.3.5-1ubuntu12.5.10.1