Build 3.0.0.49 of xlsgen adds support for the 53 new formula functions introduced by Excel 2013 (Excel 2013 is to be released this fall).
The functions are : ACOT, ACOTH, ARABIC, BASE, BINOM.DIST.RANGE, BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR, CEILING.MATH, CEILING.PRECISE, COMBINA, COT, COTH, CSC, CSCH, DAYS, DECIMAL, ERF.PRECISE, ERFC.PRECISE, FLOOR.MATH, FLOOR.PRECISE, FORMULATEXT, GAMMA, GAMMALN.PRECISE, GAUSS, IFNA, IMCOSH, IMCOT, IMCSC, IMCSCH, IMSEC, IMSECH, IMSINH, IMTAN, ISFORMULA, ISOWEEKNUM, JIS, MUNIT, NUMBERVALUE, PDURATION, PERMUTATIONA, PHI, RRI, SEC, SECH, SHEET, SHEETS, SKEW.P, UNICHAR, UNICODE, XOR
By support we mean read and write in XLS and XLSX files. Support in the calculation engine will be added incrementally over time and according to customer needs.
Our documentation page on
formulas has been updated to reflect this build.
More details about each function can be found in the
prelease documentation over on the Microsoft website.