Released: Oct 26, 2023

v7.0.0 中的更新

特性

• Calculation engine has been updated to support array formulas:
  • Added support for calculating legacy / dynamic array formulas.
  • Added support for intersect operator.
  • Added support for implicit intersection.
  • Added support for array parameters in functions.
  • Improved support for using the colon operator with functions.
  • Improved handling of circular references.
  • Added 90 new functions.
  • Optimized calculation engine with configurable expression caching.
• Conditional Formatting improvements:
  • Improved performance, XML is now read and written on load and save.
  • Added cross worksheet formula support.
  • Extended styling options for color scales, data bars and icon sets.
• Added new functions for Taking and Skipping rows/columns on a range.
• Breaking changes - Updated calculation engine.