Released: Aug 20, 2024

v7.3.0 での更新項目

機能

• Added support for 'Precision As Displayed' when calculating formulas, via the 'ExcelWorkbook.FullPrecision' property.
• Added new functions:
  • GROWTH.
  • DPRODUCT.
  • DSTDEV.
  • DSTDEVP.
• EPPlus now supports reading workbooks encoded with other encodings than UTF8.
• Added new parameter to ExcelRangeBase.CreateArrayFormula for dynamic array formulas, to set meta data for the cell.

不具合の修正

• Deleting all pivot tables in a workbook caused the workbook to become corrupt as the pivotCache element was not deleted.
• MinIfs and MaxIfs returned an incorrect value if the criteria's was an error like #NUM or #REF.
• EPPlus failed to load a workbook containing a worksheet with a space as name.
• Loading a workbook with a part exceeding 2GB failed to load.
• EPPlus failed to load a workbook when the worksheet XML had a XML prefix for the default namespace and had conditional formatting's or data validations.
• Loading pivot tables with date grouping sometimes did not convert the grouped values to dates.
• Fixed issue were EPPlus only allowed 253 characters in Data Validation List, 255 characters are now allowed.