Lançamentos do EPPlus

Released: Apr 16, 2026

Atualizações na v8.5.3

Correções

  • Fixed issue where updated .NET 8 references incorrectly update to 9.x to 8.x in EPPlus 8.5.2.

Released: Apr 16, 2026

Atualizações na v8.5.2

Recursos

  • Updated System.Security.Cryptography.Xml for .NET 9 and 10 to address a security vulnerability (CVE-2026-26171 and CVE-2026-33116).

Correções

  • ExcelRange.LoadFromCollection: DisplayAttribute.Name was used directly instead of DisplayAttribute.GetName(), causing resource keys to appear as column headers instead of localized values when ResourceType was set.
  • ExcelRange.LoadFromCollection: EpplusTableColumnAttribute.Order was ignored when DisplayAttribute was also present.
  • Fixed various...

Released: Mar 30, 2026

Atualizações na v8.5.1

Correções

  • Negation of numeric string values now returns the negated number instead of a #VALUE! error in the formula calculation.
  • 'ExcelPackage.Configure' now sets 'IConfiguration' for license info.
  • The WEEKDAY function now handles optional return-types 12-17 correctly.
  • Inserting rows or columns when a named range is on the maximum row is now handled correctly. Absolute referenced defined names become #REF! when pushed outside the maximum.
  • NUMBERVALUE function now parses decimal and group...

Released: Mar 6, 2026

Atualizações na v8.5.0

Recursos

  • Added 'CancellationToken' to Calculate.
  • Added property 'ValueFromCellsRange' and the 'SetValueFromCellsRange' method to data labels on chart series.
  • Improved performance for SUMIFS, AVERAGEIFS, COUNTIFS.
  • Improved performance for formula calculation with full column references (e.g. A:A, $B:$B).
  • Breaking Changes:
    • Setting dataLabelPosition.Top on BarCharts corrupted the Excel file when saved. Trying to set this now throws an error instead.
    • NumberFormatToTextArgs.NumberFormat now returns...

Released: Feb 4, 2026

Atualizações na v8.4.2

Correções

  • Fixed an issue where the ExcelRange.Text property could format negative values with double minus signs in rare cases.
  • Fixed a performance issue when using FollowDependencyChain set to false in the Calculate method. With this option, EPPlus no longer calculates dependent cells or dynamic array formula spills.
  • Fixed an issue where the ExcelPowerQueryMetadataItem class parsed dates using the supplied culture instead of the invariant culture, which could cause an unhandled exception.
  • Fixed...

Released: Jan 12, 2026

Atualizações na v8.4.1

Correções

  • Fixed several issues related to expanding (spilling) and contracting dynamic array formulas.
    • Changing cell dependencies were not taken into account when recalculating dirty cells from dynamic array formulas.
    • Clearing dynamic array formulas that reduced in size did not work correctly.
    • Cells containing formulas with the INDIRECT function are now always treated as dynamic.
  • Invalid UTF-16 surrogate sequences in comment text are now sanitized before XML generation to prevent 'XmlException'...

Released: Dec 12, 2025

Atualizações na v8.4.0

Recursos

  • Added support for .NET 10.

Correções

  • Fixed an issue where the DATEDIF function returned incorrect results for the number of months.
  • Fixed an issue where EPPlus incorrectly evaluated the expression TRUE equals 1 as TRUE instead of FALSE.
  • Resolved various issues in CEILING, ISOCEILING, CEILING.PRECISE, CEILING.MATH and FLOOR, FLOOR.PRECISE, FLOOR.MATH functions, especially when handling negative multiples. The TIME function was previously limited to the range 00:00:00–23:59:59. It now...

Released: Nov 28, 2025

Atualizações na v8.3.1

Correções

  • Fixed issue using an array as denominator when first value is 0 it returns a single '#DIV0' error.
  • Fixed issue where the 'FILTER' function did not work correctly when filtering on columns.
  • Fixed issue when functions that contain an "internal lambda" were called inside another function, the calling function failed in some cases.
  • Fixed issue in XLOOKUP where the argument [ifnotfound] was incorrectly converted to a string when no match was found.
  • Fixed issue where charts in Chart sheets...

Released: Nov 20, 2025

Atualizações na v8.3.0

Recursos

External Connections and Query Tables

  • Added support for adding external connections and query tables.
  • Supports adding, updating and removing connections:
    • Power query connections.
    • Database connections.
    • OLAP connections.
    • Web connections.
    • Text connections.
  • Supports adding, updating and removing range and table query tables.
  • Supports adding pivot tables with external connections as source.
  • Added 3 new functions: 'PERCENTOF', 'VALUETOTEXT' and 'BASE'.

Correções

  • Fixed issue where 'RichText...

Released: Oct 9, 2025

Atualizações na v8.2.1

Recursos

  • Added new method 'SetAutoTitle' to 'ExcelChartTitleStandard' to map chart titles on pivot charts to the pivot tables data fields.
  • Added the possibility to provide the IConfiguration of the hosting application to the ExcelPackage constructor and/or the ExcelPackage.Configure method rather than EPPlus trying to read the config files directly for license information.
  • Added cancellation tokens handing in the zip extract in the `ExcelPackage.LoadAsync` method. EPPlus will now throw an...