EPPlus Releases

Released: May 15, 2025

Updates in v8.0.5

Fixes

  • Fixed an issue with external links not getting saved in EPPlus 8.0.4.

Released: May 14, 2025

Updates in v8.0.4

Fixes

  • SUMIFS, AVERAGEIFS and COUNTIFS sometimes miscalculate due to returning the incorrect addresses to the dependency chain.
  • Range.Sort did not sort update formula addresses in some cases.
  • Fixed array support for the SUBSTITUTE, SUMIFS, AVERAGEIFS and COUNTIFS functions.
  • Incorrect handing of meta data strings caused a corrupt workbook in some situations.
  • License key validation did not work in Blazor WASM.
  • The ExcelPicture.Image.Bounds was not set when loading drawings.
  • Pivot cache fields...

Released: Apr 30, 2025

Updates in v8.0.3

Features

  • Added custom number formats where the formatId is not a built-in format.

Fixes

  • Fixed issue where SUMIFS and AVERAGEIFS sometimes miscalculated with multiple arguments.
  • Fixed issue when sorting a range with threaded comments, removing and adding a threaded comment sometimes throws an exception.
  • Fixed issue where cell meta data loaded from a workbook was cleared on formula calculation, causing some dynamic array formulas to become legacy array formulas.

Released: Apr 16, 2025

Updates in v8.0.2

Fixes

  • The CHOOSECOLS and CHOOSEROWS functions did not support ranges as a row/col selection argument.
  • When reading a string with '_xb36' from a cell, a string error was returned.
  • Pivot selection in the worksheet view was not removed when a pivot table was refreshed, causing the pivot table to become corrupt.
  • The SUMIFS and COUNTIFS functions did not consider the criteria range when checking for circular references.
  • Copying a cell after deleting and adding a comment sometimes caused an exception...

Released: Mar 28, 2025

Updates in v8.0.1

Features

  • EPPlus version 8 and later commercial licenses now require a license key to be specified before using EPPlus. This must be set both in the development and in the runtime environments.
  • Support for OLE objects (Linked or Embedded files).
  • Support for digital signing workbooks and signature lines.
  • In-cell pictures / support for the IMAGE function.
  • Sensitivity Label API to integrate with MIP (Microsoft Information Protection SDK).
  • Autofit columns optimization.
  • The Range Copy method now...

Released: Mar 17, 2025

Updates in v7.7.0

Fixes

  • Reverted System.* and Microsoft.* references to 8.0.x for all target frameworks except .NET 9.
  • Fixed issue where LoadFromArray and LoadFromDataTable of the ExcelRangeBase class did not clear existing formulas before populating the range.
  • Fixed a rare issue when copying images between named ranges.
  • Fixed issue when sorting a range with formulas, the formulas addresses were sometimes updated incorrectly.
  • Fixed issue where GetAsByteArrayAsync could not be called more than once.

Released: Mar 4, 2025

Updates in v7.6.1

Fixes

  • Fixed issue where pivot caches with error values in the source data were not handled correctly.
  • Fixed problem where timespan was not correctly converted in the GetValue function.
  • Fixed issue where the ExcelWorksheet.DimensionByValue property sometimes threw an unhandled exception.
  • Fixed error where the FIND function did not handle empty cells correctly in all cases.
  • Fixed issue where range sorting did not handle threaded comments.
  • Fixed issue where Table.AddRows incorrectly shifted the...

Released: Feb 6, 2025

Updates in v7.6.0

Features

  • Added Microsoft .NET 9 as a target framework.
  • Removed out of support frameworks - .NET 6 and .NET 7.

Fixes

  • Fixed an issue handling formulas when sorting a range.
  • Insert row in table caused corrupt workbook.
  • A workbook could lose styles if the ExcelPackage.FullPrecision property was set.
  • When copying a worksheet, drawings would be resized after inserting rows. This was caused by drawings being copied before styles and therefore drawings would not be aware of any styles.
  • Set Active Tab...

Released: Jan 16, 2025

Updates in v7.5.3

Features

  • Improved COUNTIF performance, if full column addresses was used.
  • Added null as valid GetByValue for pivot table field items.
  • Added support for [h]:mm number format.
  • Improved sorting for pivot table slicer cache.
  • Added Drawings.AddTextBox for easier creation of textboxes.

Fixes

  • If having a workbook with no reference to a font in the styles.xml, caused an corrupt workbook.
  • ZipEntry's containing the zip data descriptor header could result in a BadReadException.
  • Fixed comment indices when...

Released: Dec 9, 2024

Updates in v7.5.2

Fixes

  • Fixed issue where pivot tables with blanks could cause the pivot table to become corrupt.
  • Fixed error handling in the TEXTJOIN, TEXTSPLIT and CONCAT functions.
  • Fixed issue where an exception was thrown when trying to delete the last column in a worksheet.
  • Fixed issue where ExcelColor.LookupColor() returned an unexpected color code for empty colors. LookupColor() now returns an empty string for empty colors.
  • Fixed issue where DimensionByValue would throw an System.ArgumentException: 'Column...