Build 5.0.0.67 of xlsgen is a fix pack for pivot tables.


It has the following :

- additional integrity check meant to avoid the #SPILL! error message introduced in recent Excel versions in conjunction to pivot tables.

- improved writing of pivot tables in XLSX and XLSB files meant to avoid the #SPILL! error message in pivot tables

- improved writing of pivot tables in XLS, XLSX and XLSB files to add pivot drop downs

Build 5.0.0.66 of xlsgen updates the security level of two library dependencies :

- libPNG 1.6.56 ==> 1.6.58 (used for r/w PNG pictures)
- libWEBP 1.5.0 ==> 1.6.0 (used for r/w WEBP pictures)

Build 5.0.0.65 of xlsgen introduces a formula hinter, meant to ease the use of formulas in cells. At the workbook level, calling IsFormulaADate(formula), along with a formula, returns whether or not the formula returns a date. This is handy if you'd like to know beforehand the formula is going to need a specific cell number format, and act accordingly.

interface IXlsWorkbook, one new function
    IsFormulaADate([in]BSTR formula, [out, retval]BOOL* result);