Released: Apr 16, 2026

v8.5.3 버젼 업데이트

수정사항

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

Released: Apr 16, 2026

v8.5.2 버젼 업데이트

기능

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

수정사항

• 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 issues with the...

Released: Mar 30, 2026

v8.5.1 버젼 업데이트

수정사항

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

Released: Mar 6, 2026

v8.5.0 버젼 업데이트

기능

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

Released: Feb 4, 2026

v8.4.2 버젼 업데이트

수정사항

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

Released: Jan 12, 2026

v8.4.1 버젼 업데이트

수정사항

• 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

v8.4.0 버젼 업데이트

기능

• Added support for .NET 10.

수정사항

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

Released: Nov 28, 2025

v8.3.1 버젼 업데이트

수정사항

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

Released: Nov 20, 2025

v8.3.0 버젼 업데이트

기능

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

수정사항

• Fixed issue where 'RichText.Clear' caused...

Released: Oct 9, 2025

v8.2.1 버젼 업데이트

기능

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