xlsgen, native Excel generator

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

xlsgen 5.0.0.62 : Fix pack for pivot tables

ARsT design — Mon, 29 Dec 2025 00:22:17 GMT

Build 5.0.0.62 of xlsgen is a fix pack related to pivot tables. Precisely :

- improved rendering of page field names
- improved rendering of rows in Compact layout mode.
- better writing of row items section in pivot tables. 1) no longer adds page filters 2) takes into account unselected items (normal items and page filters)
- code refactoring
- codegen : improved InsertAt() row calculation (when pivot table has page filters)
- better page filters in pivot tables by taking really them into account when trees are built.
- support for rendering number formats in calculated columns or data fields

xlsgen 5.0.0.61 : Fix for large pivot tables

ARsT design — Thu, 18 Dec 2025 17:09:57 GMT

Build 5.0.0.61 of xlsgen is a performance fix for working with creating large pivot tables. Another o(n2) algorithm gets removed.

xlsgen 5.0.0.60 : Security update

ARsT design — Tue, 16 Dec 2025 16:05:15 GMT

Build 5.0.0.60 of xlsgen is a security update. It updates libpng internally used (library for processing PNG pictures), taking it to the latest 1.6.53 (as of date), thereby fixing 5 vulnerabilities (2 moderate and 3 high).

xlsgen 5.0.0.59 : Fix for search counts

ARsT design — Sun, 7 Dec 2025 22:37:17 GMT

Build 5.0.0.59 of xlsgen fixes a problem in the API related to searching stuff in Excel files. The results were incorporating non-matches. Now no more.

xlsgen 5.0.0.58 : Improved Lookup() calculation

ARsT design — Thu, 4 Dec 2025 17:53:01 GMT

Build 5.0.0.58 of xlsgen improves how the Lookup() function gets calculated under special circumstances.

In normal Lookup() usage, the first parameter is the value to look up, the second parameter is the vector to look into and the third parameter is the vector for return data (both vectors must have the same size and the look up vector must be sorted).

The special circumstances is the ability to pass only 2 parameters and both vectors are specified using an area, as second parameter. The first column of the area acts as a look up vector, and the last column acts as a vector for return data.

In other words, instead of passing =Lookup(2;B3:B10;C3:C10), you can pass =Lookup(2;B3:C10) and the result is the same.

xlsgen 5.0.0.57 : Fix for conditional formattings

ARsT design — Thu, 4 Dec 2025 09:33:09 GMT

Build 5.0.0.57 of xlsgen fixes a problem related to reading conditional formattings from XLSX/XLSM files where under certain circumstances, the computation or manipulations (copy/delete/move) were not being done properly.

xlsgen 5.0.0.56 : Fix for drawings

ARsT design — Wed, 22 Oct 2025 14:29:36 GMT

Build 5.0.0.56 of xlsgen fixes a problem related to duplicating shapes (including pictures). The name and alternate text are now duplicated as well. If this applies, a unique name for the shape is created to avoid conflicts.

xlsgen 5.0.0.55 : Fix for merged cells and views

ARsT design — Sun, 19 Oct 2025 13:40:24 GMT

Build 5.0.0.55 of xlsgen tightens the screws when generating Excel files in two areas : merged cells and custom sheet views. xlsgen makes sure that the file keeps consistent and Excel does not report that the resulting file is corrupt.