Subject: | getCellValue returns the wrong value with 'time' cells |
OpenOffice can use two different values when dealing with certain table
cells. This is true when the cells contain date information, in that
case OpenOffice will store a canonical value in the cell's attribute and
a dislayable value in the cell's content. The method getCellValue()
handles this properly with cells of type 'date' but it doesn't do it
with cells of type 'time'.
The patch that I have submitted addresses fix the issue.
Perhaps the same should be done with the other possible data types.
Subject: | Text.pm.patch |
--- /usr/share/perl5/OpenOffice/OODoc/Text.pm 2007-07-14 16:25:05.000000000 +0200
+++ /home/emmanuel/sandbox/debian/perl/OpenOffice-OODoc-2.035/OODoc/Text.pm 2007-05-12 14:53:56.000000000 +0200
@@ -2689,10 +2689,6 @@
{ # thanks to Rafel Amer Ramon
return $cell->att($prefix . ':date-value');
}
- elsif ($cell_type eq 'time') # date
- { # A time value
- return $cell->att($prefix . ':time-value');
- }
else # numeric
{
return $cell->att($prefix . ':value');