just text |
filled or empty data table |
just text |
template text and styling is migrated 'as is' |
{{column_name}} |
one row in the data table with the value (string)test |
test |
the row will not be expanded as there is a single value only. Can be used in worksheet names too. |
{{column_name}} |
multiple rows in the data table with values (string)test and (string)test2 |
row 1: test; row 2: test |
the data will expand vertically on new rows. |
{{column_name(F=H)}} |
multiple rows in the data table with values (string)test and (string)test2 |
row 1: test; row 2: test |
the data will expand horizontally on new rows. |
{{column_name(S=", ")}} |
multiple rows in the data table with values (string)test and (string)test2 |
test, test2 |
rows will not be expanded as the separator will join the data in a single value. |
text {{column_name[0]}} text |
multiple rows in the data table with values (string)test and (string)test2 |
text test text |
tags can be used mixed with text. |
{{=sum(A1)}} |
multiple rows in the data table with value column - (int)1 and (int)2. The A1 cell is the template {{value}} |
3 as number |
tag with leading = declares a function. More about functions read in the next page. |
{{==sum(A1)}} |
multiple rows in the data table with value column - (int)1 and (int)2. The A1 cell is the template {{value}} |
=sum(A1,A2) as spreadsheet function |
tag with leading == declares an excel function. More about excel functions read in the next page. |
{{=sum(A1:B1)}} |
multiple rows in the data table |
sum of the numeric values in the expanded region |
the region reference can be provided as an address like A1:B1 too |
{{=sum(A1:B1,C2:C3)}} |
multiple rows in the data table |
sum of the numeric values in the expanded regions |
the referenced regions can be more then one, provided their addresses are separated with , |