[Feature Request]: Enable Excel functions on templates

[imdevlord]

Hi there,

The formatters from Carbone can be quite limited when comparing to Excel functions. It would be great to use Excel functions from generated data.

The most simple example:
Having two columns that are displaying values, we could have a column in a table that performs operations from the other values.

Another really important use case:
Having a cell at the end of a column that sums the total of that table column.

Thank you.

[dgrelaud]

Hi,

You can use {d.value:formatN} formatters to convert number into Excel type number.
You can do some operations (totals, and formula. It works better in ODS files than XLSX files.
Yes, I admit it is hard to do sometimes and doesn't work in all cases 🤔

We will work on it in January/February 2021.
Currently, we focus on charts in DOCX & ODT, html conversion, On-premise Entreprise-Edition, add syntax error debugging tools, and some small fixes.

David.