Build 4.0.0.59 of xlsgen fixes a problem related to the calculation of the SUBTOTAL() function when its first argument, a function identifier, is one of those special functions targeted for ignoring hidden values. Indeed, the function identifiers used in subtotals can be : average, count, counta, max, min, product, stdev, stdevp, sum, var and varp with an identifier within [1,11]. And then the special mode, for ignoring hidden values, whose identifiers are within [101,111].