...
- ExcelTemplate allows data markers in tab names of XLSX/XLSM files
- ExcelApplication support for remaining Excel 2007, 2010, and 2013 formulas:
- Excel 2007:
- DATESTRING, LEFTB, LENB, MIDB, NUMBERSTRING
- IFERROR, DBCS, USDOLLAR, GETPIVOTDATA
- EFFECT, FVSCHEDULE, INTRATE, MDURATION, NOMINAL, RECEIVED, TBILLEQ, XIRR, XNPV
- ACCRINT, ACCRINTM, AMORDEGRC, AMORLINC, CUMIMPT, CUMPRINC, DISC, DOLLARDE, DOLLARFR, DURATION, ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD, PRICE, PRICEDISC, PRICEMAT, TBILLPRICE, TBILLYIELD, YIELD, YIELDDISC, YIELDMAT
- COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD
- BESSELI, BESSELJ, BESSELK, BESSELY, COMPLEX, CONVERT, DELTA, ERF, ERFC, GESTEP
- IMABS, IMAGINARY, IMARGUMENT, IMCONJUGATE, IMCOS, IMDIV, IMEXP, IMLN, IMLOG10, IMLOG2, IMPOWER, IMPRODUCT, IMREAL, IMSIN, IMSQRT, IMSUB, IMSUM
- BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX
- CUBEKPIMEMBER, CUBEMEMBER, CUBEMEMBERPROPERTY, CUBERANKEDMEMBER, CUBESET, CUBSETCOUNT, CUBEVALUE
- Excel 2010:
- NETWORKDAYS.INTL, WORKDAY.INTL
- ERF.PRECISE, ERFC.PRECISE
- AGGREGATE, CEILING.PRECISE, FLOOR.PRECISE, ISO.CEILING
- BETA.DIST, BETA.INV, BINOM.DIST, BINOM.INV, CHISQ.DIST, CHISQ.DIST.RT, CHISQ.INV, CHISQ.INV.RT, CHISQ.TEST, CONFIDENCE.NORM, CONFIDENCE.T, COVARIANCE.P, COVARIANCE.S, F.DIST, F.DIST.RT, F.INV, F.INV.RT, F.TEST, GAMMA.DIST, GAMMA.INV, LOGNORM.DIST, LOGNORM.INV, MODE.MULT, MODE.SNGL, NORM.DIST, NORM.INV, NORM.S.DIST, NORM.S.INV, PERCENTILE.EXC, PERCENTILE.INC, PERCENTRANK.EXC, PERCENTRANK.INC, QUARTILE.EXC, QUARTILE.INC, RANK.AVG, RANK.EQ, STDEV.P, STDEV.S, VAR.P, VAR.S, T.DIST, T.DIST.2T, T.DIST.RT, T.INV, T.INV.2T, T.TEST, ECMA.CEILING, EXPON.DIST, GAMMALN.PRECISE, HYPEGEOM.DIST, NEGBINOM.DIST, POISSON.DIST, WEIBULL.DIST, Z.TEST
- Excel 2013:
- ACOT, ACOTH, ARABIC, BASE, CEILING.MATH, COMBINA, COT, COTH, CSC, CSCH, DECIMAL, FLOOR.MATH, SEC, SECH
- BION.DIST.RANGE, GAMMA, GAUSS, PERMUTATIONA, PHI, SKEW.P
- BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR, IMCOSH, IMCOT, IMCSC, IMCSCH, IMSEC, IMSECH, IMSINH, IMTAN
- DAYS, ISOWEEKNUM
- ENCODEURL, FILTERXML, WEBSERVICE
- FORMULATEXT, IFNA, ISFORMULA, NUMBERVALUE, PDURATION, RRI, SHEET, SHEETS, UNICHAR, UNICODE, XOR
- Excel 2007:
Issues Resolved
All issues are resolved in ExcelApplication for XLSX files only unless otherwise indicated
...
- PivotTable API for OOXML files with ExcelApplication
- Create PivotTables from scratch
- Modify existing PivotTables
- Change the data source for PivotTables copied with Worksheets.CopySheet(Worksheet, Int32, String)
- Support for Excel 2007 statistical formulas
- AVERAGEIF, AVERAGEIFS, COUNTIFS, MINA
- Convert numeric strings to integers with DataImportProperties.ConvertStrings for Worksheet.ImportData with ExcelApplication
...