Not grabbing multiple values if they are the same

I wanted to build an awesome place for people to discuss module specific issues, but I don't have any more time for this, and there are much better places to discuss Perl-related issues. I'd recommend asking your question on Stack Overflow or on Perl Monks.
If you are looking for a Perl tutorial or Perl-related news, I hope these links will serve you well.

Posted on 2006-02-08 16:12:57-08 by cmillward

I have a spreadsheet where the values look like this

1 2 2 2 1.5 3 3 3 1 1

If I run the following code on it the results I get

for my $row (@otherRows) { my @rcell = $doc->getRowCells($row); for (my $i=0; $i<@title; $i++) { print $doc->getCellValue($rcell[$i])." "; } print "\n"; }

Results 1 2 1.5 3 1

Am I implementing this wrong or is it a problem in the module?
Using OpenOffice-OODoc-2.022

Direct Responses: 1771 | Write a response

Posted on 2006-02-08 16:30:24-08 by mlcohen in response to 1770

Re: Not grabbing multiple values if they are the same

You probably didn't call normalizeSheet() on the spreadsheet. Openoffice compresses spreadsheets when saving, so there's probably some kind of tag telling it to repeat a cell a few times. Unless you call normalizeSheet() on the spreadsheet, I think it will probably miss the repeated cells.
-Matt

Direct Responses: Write a response