Released: Jun 16, 2026

Atualizações na v8.6.1

Recursos

• Added 3 new functions:
  • REGEXEXTRACT
  • REGEXREPLACE
  • REGEXTEST

Correções

• Fixed mismatch in conditional formatting when loading a workbook.
• Fixed several issues in the HTML export.
• Text rotated vertically in cells now adjusts column widths more appropriately.
• Borders sometimes disappeared when having rotate the text.
• Fixed bug where the positions/visuals of images would sometimes not appear.
• Pattern fills with empty colors did not pick the correct theme color.
• Merged cells did not render...

Released: May 29, 2026

Atualizações na v8.6.0

Recursos

• Added 9 new functions:
  • GROUPBY
  • PIVOTBY
  • TRIMRANGE
  • WRAPROWS
  • WRAPCOLS
  • USDOLLAR
  • CODE
  • ENCODEURL
  • ISFORMULA
• Added support for the trim reference operators.
• Ranges can now convert their values to rich text via ConvertToRichText() e.g. ws.Cells["A1"].ConvertToRichText().
• Calculation of dynamic array formulas now support dirty cell recalculation inside other dirty cell calculations.

Correções

• Fixed a cache issue with the IF function when recalculation dynamic array formulas with dirty cells...

Released: Apr 30, 2026

Atualizações na v8.5.4

Recursos

• Added IncludeInHtmlOnly option to the ePictureInclude enum. This allows the HTML Exporter to include pictures directly in the HTML output rather than in the CSS.
• Upgraded several referenced packages.

Correções

• When recalculating spilling dynamic array formulas EPPlus did not always follow new dependent addresses.
• The SUMIFS/COUNTIFS/AVERAGEIFS functions now evaluate date string literal criteria correctly.
• Workbooks containing extended charts or unsupported drawing types (like diagrams...

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...