Dear all,
I need to get the numeric values of a spreadsheet (that actually are the
numeric values of a "button radio" field from an exported data base to .ods).
When I try to get the value of the cell using 'getCellValue', the program
gives wrong values or none value at all; if I print the number of row and
column are correct, but 'getCellValue' gives an incorrect result.
Additionally, if I don't stop the program manually continues indefinitely,
beyond the end of the spreadsheet.
Any suggestions?
while($valor_numeric ne '*****') {
$num_fila++;
#gets column number from a hash.
my $num_columna= $camps{$categoria};
print "$categoria, $num_columna\n";
my $valor_numeric= $doc->getCellValue(0, $num_fila,
$num_columna);
print "$num_fila, $num_columna, $categoria, $valor_numeric\n";
my $valor_alfanumeric= $categoria{$valor_numeric};
chomp($valor_alfanumeric);
$doc->updateCell(0, $num_fila, $num_columna, $valor_numeric,
$valor_alfanumeric);
$doc->save('my_other_file.ods');
}
--
Xavier Mas
______________________________________________
LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
