xlsgen, native Excel generator

xlsgen 5.0.0.69 : Improved CELL() function

ARsT design — Sun, 9 Aug 2026 11:21:47 GMT

Build 5.0.0.69 of xlsgen improves the CELL() function. It implements a number of the following parameter commands including "address", "col", "contents", "filename", "protect", "row", "sheet", "type", "width" and "formula".

This build also fixes a problem related to duplicating some of Excel extended functions across sheet tabs.

xlsgen 5.0.0.68 : Fix pack for pivot tables (II)

ARsT design — Thu, 30 Jul 2026 16:37:00 GMT

Build 5.0.0.68 of xlsgen continues what was built with xlsgen 5.0.0.67 (avoiding the #SPILL! error message in pivot tables) and now includes XLS files as well.

xlsgen 5.0.0.67 : Fix pack for pivot tables

ARsT design — Mon, 27 Jul 2026 17:23:45 GMT

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

xlsgen 5.0.0.66 : Security update

ARsT design — Fri, 8 May 2026 23:54:17 GMT

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)

xlsgen 5.0.0.65 : Formula date hinter

ARsT design — Wed, 15 Apr 2026 23:38:21 GMT

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);

xlsgen 5.0.0.64 : Security update (II)

ARsT design — Mon, 30 Mar 2026 13:23:07 GMT

Build 5.0.0.64 of xlsgen updates the security level of libPNG (responsible for manipulating PNG pictures) :

- libPNG 1.6.55 ==> 1.6.56

xlsgen 5.0.0.63 : Security update

ARsT design — Fri, 27 Feb 2026 00:19:23 GMT

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

- libPNG 1.6.53 ==> 1.6.55
- libZLIB 1.3.1 ==> 1.3.2