Calc Expression

Calculation functions calculate inner expression and write result as output. Currently, a function subset of our Calc engine has been adapted to use with the template engine and hence the feature supports various binary, unary and arithmetic operators, aggregate functions, and text functions. The examples below show how to use aggregate and arithmetic operations to create expressions in Calc function.

    var doc = new GcWordDocument();
    doc.DataTemplate.DataSources.Add("a", new int[] { 1, 2, -2, 16, 7, 5, 4 });
    
 // aggregate function
    doc.Body.Paragraphs.Add("Aggregate function results:", doc.Styles[BuiltInStyleId.Heading2]);
    var p = doc.Body.Paragraphs.Add("{{ calc Sum(a.value) }}");
    
// arithmetic function
    doc.Body.Paragraphs.Add("Arithmetic function results:", doc.Styles[BuiltInStyleId.Heading2]);
    doc.Body.Paragraphs.Add("{{calc a.value * 2 + 12  }}");
    doc.DataTemplate.Process();
    doc.Save("Calculation.docx");

To view Calc functions in action, see Calculation demo sample.

Limitations

• Calc functions cannot be used without at least one datasource added to DataTemplate.
• Function names are reserved and cannot be used inside data sources. This limitation is case in-sensitive and limits only simplified names. So if you have datasource field ds.count, you can use it as {{calc ds.count*5}}. Engine fails to process if you use it as {{calc count*5}}.
• Aggregate functions cannot be used with expressions as parameters. They only allow using a single tag. For example, {{calc Sum(a.b)}} works fine while {{calc Sum(a.b+b.c)}} gives error.