Build 3.0.0.41 of xlsgen is a fix pack.
The following fixes are added :
- SUMIFS()/COUNTIFS()/AVERAGEIFS() calculation fixed. Array algorithm could interfere and return an array of results instead of a literal.
- internal expanding of cell references in calculation engine is fixed. Could have carried more than one literal.
- FormattedLabel(r,c) function fixed in cases where the cell isn't a date and the number format is a date.
- handling of number formats of the form [hh]:mm.
- Fix handling of empty data in cells of type date.
As a result of improving FormattedLabel(r,c), there is an improvement in the output of print/preview/PDF/XPS.
No source code change needed.