Thread

Posted on Wed Feb 8 18:12:57 2006 by cmillward
Not grabbing multiple values if they are the same
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 Wed Feb 8 18:30:24 2006 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
Write a response