From fba724a60fad258b7b2b0279e1aabbf7b5704aec Mon Sep 17 00:00:00 2001
From: Jesse Luehrs <doy@tozt.net>
Date: Tue, 4 Jun 2013 18:36:37 -0500
Subject: write out formulas properly

---
 lib/Spreadsheet/Template/Writer/Excel.pm | 20 +++++++++++++++-----
 1 file changed, 15 insertions(+), 5 deletions(-)

diff --git a/lib/Spreadsheet/Template/Writer/Excel.pm b/lib/Spreadsheet/Template/Writer/Excel.pm
index 58cc0c1..25efe99 100644
--- a/lib/Spreadsheet/Template/Writer/Excel.pm
+++ b/lib/Spreadsheet/Template/Writer/Excel.pm
@@ -209,11 +209,21 @@ sub _write_cell {
 
     # XXX handle merged cells
 
-    $sheet->$write_method(
-        $row, $col,
-        $data->{contents},
-        (defined $format ? ($format) : ()),
-    );
+    if (defined $data->{formula}) {
+        $sheet->write_formula(
+            $row, $col,
+            $data->{formula},
+            (defined $format ? ($format) : (undef)),
+            $data->{contents},
+        );
+    }
+    else {
+        $sheet->$write_method(
+            $row, $col,
+            $data->{contents},
+            (defined $format ? ($format) : ()),
+        );
+    }
 }
 
 sub _color {
-- 
cgit v1.2.3-54-g00ecf