diff options
author | Jason <jason@socialflow.com> | 2013-08-28 15:16:28 +0000 |
---|---|---|
committer | Jason <jason@socialflow.com> | 2013-08-28 15:16:28 +0000 |
commit | 2d06ee894a3e5cd139bde1a88095c33772283e99 (patch) | |
tree | 9547431e882c1454895b47dfd95a3ef3a939f1e9 /t/data | |
parent | da21e2cca6a714c09b35115ac9e51f39f21f3d40 (diff) | |
download | spreadsheet-template-2d06ee894a3e5cd139bde1a88095c33772283e99.tar.gz spreadsheet-template-2d06ee894a3e5cd139bde1a88095c33772283e99.zip |
merge now supports formulas, and adjusted test
Diffstat (limited to 't/data')
-rw-r--r-- | t/data/merge.json | 32 |
1 files changed, 23 insertions, 9 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)') %] + ] } ] } |