diff options
Diffstat (limited to 'lib/Spreadsheet/Template/Generator/Parser/Excel.pm')
-rw-r--r-- | lib/Spreadsheet/Template/Generator/Parser/Excel.pm | 9 |
1 files changed, 3 insertions, 6 deletions
diff --git a/lib/Spreadsheet/Template/Generator/Parser/Excel.pm b/lib/Spreadsheet/Template/Generator/Parser/Excel.pm index 0e12e66..40f2744 100644 --- a/lib/Spreadsheet/Template/Generator/Parser/Excel.pm +++ b/lib/Spreadsheet/Template/Generator/Parser/Excel.pm @@ -82,17 +82,13 @@ sub _parse_cell { my $contents = $cell->unformatted; my $type = $cell->type; + my $formula = $cell->{Formula}; # XXX if ($type eq 'Numeric') { $type = 'number'; } elsif ($type eq 'Text') { - if ($contents =~ /^=/) { - $type = 'formula'; - } - else { - $type = 'string'; - } + $type = 'string'; } elsif ($type eq 'Date') { $type = 'date_time'; @@ -104,6 +100,7 @@ sub _parse_cell { my $data = { contents => $self->_filter_cell_contents($contents, $type), type => $type, + ($formula ? (formula => $formula) : ()), }; return $data; |