Build 5.0.0.74 of xlsgen is a security update for a dependency of xlsgen called libPNG (r/w pictures with PNG file format).

libpng 1.6.58 ==> 1.6.59

Build 5.0.0.73 of xlsgen fixes a problem related to strings that can't be inserted in cells because they are reaching the internal limit. Cells have a 32 KB char limit each one. To make sure crossing the limit does not crash xlsgen or the created Excel files, xlsgen limits strings to 32 KB in each cell.

Build 5.0.0.72 of xlsgen fixes a problem related to handling existing conditional formattings with insert/delete row/col manipulations.

Build 5.0.0.71 of xlsgen fixes how table column names containing special characters are parsed, so they are parsed correctly and written back correctly as well.

Build 5.0.0.70 of xlsgen ensures that sheet-level metadata on cells get copied on sheet duplicate scenarios. Metadata is used by Excel for dynamic formula tagging, for instance.

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.

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.

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

Sans surprise, les cadors de l'IA puisent leurs fuites en avant respectives dans tous les ressorts du capitalisme classique, à savoir pratique anti-concurrentielle, manque d'intégrité des résultats en fonction de considérations géopolitiques, et évidemment l'inévitable tarification exponentielle. Tout est en place pour que ça explose en plein vol...

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

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

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

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

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

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

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.

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.

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.

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.