Build 2.5.0.94 of xlsgen preserves all Excel 2007 table formulas in all Excel 2007 file related scenarios. Excel 2007 table formulas are a mechanism by which a column can be referenced by the name of its header, projections can be applied, and calculations can take any of this as argument.

Examples of Excel 2007 table formulas are :

=SUM([PRICE])

=DeptSales[[#Headers],[ComPct]]

For a full reference on the subject, here is a link to an article over at Microsoft.com

By preserving Excel 2007 table formulas, xlsgen ensures better fidelity of Excel 2007 file related scenarios without explicitely supporting tables. Note that xlsgen does not calculate those formulas.