[MTHURN - Wed Sep 14 10:11:33 2005]:
Show quoted text> I consider it a bug that xlscat outputs <empty-string> where the cell
> actually contains numeric zero.
Please state the backend: CSV, XLS, or SXC
I /think/ you are working with Excel, because I just checked a fresh xls
sheet where I entered in sequence
1. A1
2. a space
3. nothing
4. a 0
5. a 1
6. a '
and some comments on the second line. With some debug info, I got
1:1 'A1' / 'A1'
2:1 ' ' / ' '
3:1 '-- undef --' / '-- undef --'
4:1 '-- undef --' / '-- undef --'
5:1 '1' / '1'
6:1 '-- undef --' / '-- undef --'
A1||||1|
1:2 'label' / 'label'
2:2 'space' / 'space'
3:2 'empty' / 'empty'
4:2 'nul' / 'nul'
5:2 'one' / 'one'
6:2 'A single quote' / 'A single quote'
label|space|empty|nul|one|A single quote
6 x 2
And a dump of the Spreadsheet::Parse internals shows me:
'PkgStr' => [
{ 'Ext' => '',
'Rich' => '',
'Text' => 'A1',
'Unicode' => 0
},
{ 'Ext' => '',
'Rich' => '',
'Text' => ' ',
'Unicode' => 0
},
{ 'Ext' => '',
'Rich' => '',
'Text' => '',
'Unicode' => 0
},
{ 'Ext' => '',
'Rich' => '',
'Text' => 'A single quote',
'Unicode' => 0
},
{ 'Ext' => '',
'Rich' => '',
'Text' => 'empty',
'Unicode' => 0
},
{ 'Ext' => '',
'Rich' => '',
'Text' => 'space',
'Unicode' => 0
},
{ 'Ext' => '',
'Rich' => '',
'Text' => 'label',
'Unicode' => 0
},
{ 'Ext' => '',
'Rich' => '',
'Text' => 'nul',
'Unicode' => 0
},
{ 'Ext' => '',
'Rich' => '',
'Text' => 'one',
'Unicode' => 0
}
],
'SheetCount' => 2,
Which IMHO makes your remark qualify as a Spreadsheet::ParseExcel bug
RT for rt.cpan.org