| Subject: | problem with recent openoffice |
| Date: | Sun, 04 Sep 2011 18:31:43 +0200 |
| To: | bug-Spreadsheet-ReadSXC [...] rt.cpan.org |
| From: | hamann.w [...] t-online.de |
Hi, it seems that xlscat fails on newer ods files. I traced it down to
office now including some extra whitespace within tags.
It seems to help to change code like this:
sub char_start {
my ($expat, $content) = @_;
# don't include paragraph if part of an annotation
if ( $expat->within_element('office:annotation') ) {
return;
}
# don't include covered cells, if not requested
if ( ( $expat->within_element('table:covered-table-cell') ) and ( ! $options{IncludeCoveredCells} ) ) {
return;
}
# add paragraph or textspan to current @cell array
if ( $table && ($text_p >= 0) ) {
$cell[$text_p] .= $content;
Regards
Wolfgang Hamann