Build 4.5.0.50 of xlsgen adds support for calculating table formulas, that is, formula expressions including one or more table structured references, such as :
- Table1[Sales] // Sales column
- Table1[[Sales]:[Income]] // Column range : Sales, ..., Income
- Table1[[#Headers];[Sales]] // Header rows from the Sales column
Table formulas can appear anywhere : in cells, in objects (conditional formattings, ...), in defined names, ...