Build 3.5.0.17 of xlsgen fixes a common problems in the calculation engine whenever one of the following functions is involved :
VLOOKUP, HLOOKUP, LOOKUP, MATCH, MEDIAN, STDEV, STDEVP, VAR, VARP, STDEVA, STDEVPA, VARA, VARPA, RANK, LARGE, SMALL, CORREL, AVEDEV, KURTOSIS, TRIMMEAN, DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP, LOGEST, LINEST, SLOPE, INTERCEPT, FREQUENCY, SUMPRODUCT
Before this build, the functions above would parse their arguments and extract cell references only as last known value in the corresponding cells, not calculating the cells, which leads to an incorrect calculation tree and therefore an incorrect value.