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.