merge now supports formulas, and adjusted test

2 files changed, 51 insertions, 12 deletions

diff --git a/t/data/merge.json b/t/data/merge.json
index 2a86bdf..5dc32f3 100644
--- a/t/data/merge.json
+++ b/t/data/merge.json
@@ -1,5 +1,5 @@
 %% my $default = { color => '#000000', size => 14 };
-%% format(basic => $default.merge({bold => true()}));
+%% format(basic => $default.merge({bold => true(),align => 'left'}));
 
 {
    "selection"  : 0,
@@ -10,18 +10,32 @@
          "selection"     : [ 1, 9 ],
          "row_heights"   : [ 25, 18, 18, 18 ],
          "cells"         : [
+            %% for $headers -> $header {
+            [
+               [% c($header.value1, "basic") %],
+               [% c($header.value2, "basic") %],
+               [% c($header.value3, "basic") %],
+               [% c($header.value4, "basic") %]
+            ],
+            %% }
             %% for $rows -> $row {
             [
-               [% c($row.value1, "basic") %],
-               [% c($row.value2, "basic") %],
-               [% c($row.value3, "basic") %],
-               [% c($row.value4, "basic") %]
-            ]
+               [% c($row.value1, "basic", "number") %],
+               [% c($row.value2, "basic", "number") %],
+               [% c($row.value3, "basic", "number") %],
+               [% c($row.value4, "basic", "number") %]
+            ],
             %% }
+            [
+                [% c(0, "basic", "number" ) %]
+            ]
          ],
-        "merge" : [
-            [% merge('A1:D1', 'Merged Cells', 'basic') %]
-        ] 
+         "merge" : [
+            [% merge('Merged Header', 'basic', 'string','A1:D1') %],
+            [% merge($rows.map(-> $a {$a.value1}).reduce(-> $a,$b {$a + $b}), 'basic', 
+                 'number', 
+                 'A4:D4', formula => 'SUM(A2:A3)') %]
+         ] 
       }
    ]
 }
diff --git a/t/merge.t b/t/merge.t
index c04c0ab..0d270db 100644
--- a/t/merge.t
+++ b/t/merge.t
@@ -15,12 +15,26 @@ my $data = do { local $/; local @ARGV = ('t/data/merge.json'); <> };
     my $excel = $template->render(
         $data,
         {
-            rows => [
+            headers => [
                 {
                     value1 => "Merge 1",
                     value2 => "Merge 2",
                     value3 => "Merge 3",
                     value4 => "Merge 4"
+                },
+            ],
+            rows => [
+                {
+                    value1 => "1",
+                    value2 => '0',
+                    value3 => '0',
+                    value4 => '0'
+                },
+                {
+                    value1 => "2",
+                    value2 => '0',
+                    value3 => '0',
+                    value4 => '0'
                 }
             ],
         }
@@ -33,15 +47,26 @@ my $data = do { local $/; local @ARGV = ('t/data/merge.json'); <> };
     my $ws = $wb->worksheet(0);
     is($ws->get_name, 'Merge Report 1');
 
-    # In the template, the 4 columns are merged
+    # In the template, the 4 columns in row 1 are merged
     # with contents = "Merged Cells"
     for my $col (0..3) {
         if ($col == 0) {
-            is($ws->get_cell(0, $col)->value, 'Merged Cells');
+            is($ws->get_cell(0, $col)->value, 'Merged Header');
         } else {
             is($ws->get_cell(0, $col)->value, '');
         }
     }
+    is($ws->get_cell(1,0)->value, 1);
+    is($ws->get_cell(2,0)->value, 2);
+    my $value1 = $ws->get_cell(1,0)->value;
+    my $value2 = $ws->get_cell(2,0)->value;
+    my $sum = $value1 + $value2;
+    is($ws->get_cell(3,0)->value, $sum);
+
+    open my $fh2, '>', 'out.xlsx';
+    binmode $fh2;
+    $fh2->print($excel);
+    $fh2->close;
 }
 
 done_testing;