Page History

...

• 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

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

...