Skip to content

EPPlus 7

Jump to bottom
JanKallman edited this page Oct 26, 2023 · 3 revisions

EPPlus 7 has a new calculation engine with improved performance and many new features/capabilities. The most notable features includes support for arrayformulas/dynamic arrayformulas/spillover and support for several new functions that depends on this functionality. We have also improved the support for handling of complex addresses and usage of operators with ranges/addresses and reduced floating point errors/improved precision in sums, averages, etc.

New functions supported

  • XMATCH
  • XLOOKUP
  • FREQUENCY
  • FILTER
  • TRANSPOSE
  • HSTACK
  • VSTACK
  • TAKE
  • DROP
  • SINGLE
  • SORT
  • SORTBY
  • UNIQUE
  • ANCHORARRAY
  • CHOOSECOLS
  • CHOOSEROWS
  • EXPAND
  • RANDARRAY
  • SEQUENCE
  • TOCOL
  • TOROW
  • CHISQ.TEST
  • GESTEP
  • IMAGINARY
  • IMARGUMENT
  • IMCONJUGATE
  • IMCOS
  • IMCOT
  • IMCOSH
  • IMCSC
  • IMCSCH
  • IMDIV
  • IMLN