|
It seems to me that getTableText has some strange behavior when it comes to empty cells/columns.
#!/usr/bin/perl -w
use strict;
use OpenOffice::OODoc;
my $doc= ooDocument(file => "test.ods");
$doc->{'field_separator'}= ",\t";
my $sheet= $doc->getTableText("Sheet1", 1000, 1000);
print $sheet;
and my ods test file contains
1 6 9 13
2 10
3 15
4 7 12 16
5 8
(i.e., C column and E columns are blank. 10 appears in D column. 15 in F column.)
The output of my program, however, is
Argument "1.15_02" isn't numeric in subroutine entry at /usr/lib/perl5/site_perl//5.8.8/OpenOffice/
+OODoc/File.pm line 16.
1, 6, , 9, , 13
2, , 10, ,
3, , , , 15
4, 7, , 12, , 16
5, 8,
|