Build 4.0.0.23 of xlsgen fixes the parser used in common expressions in formulas with COUNTIF()/SUMIF() and AVERAGEIF(). The expression to compare to was not supporting all operator cases, and all operand cases, which could return in the calculation engine unable to compute the value in such a cell.