Released: Apr 16, 2026
Aggiornamenti in v8.5.3
Correzioni
- Fixed issue where updated .NET 8 references incorrectly update to 9.x to 8.x in EPPlus 8.5.2.
Released: Apr 16, 2026
Aggiornamenti in v8.5.2
Funzionalità
- Updated System.Security.Cryptography.Xml for .NET 9 and 10 to address a security vulnerability (CVE-2026-26171 and CVE-2026-33116).
Correzioni
- 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
Aggiornamenti in v8.5.1
Correzioni
- 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
Aggiornamenti in v8.5.0
Funzionalità
- 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...
Released: Feb 4, 2026
Aggiornamenti in v8.4.2
Correzioni
- 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...
Released: Jan 12, 2026
Aggiornamenti in v8.4.1
Correzioni
- 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
Aggiornamenti in v8.4.0
Funzionalità
- Added support for .NET 10.
Correzioni
- 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...
Released: Nov 28, 2025
Aggiornamenti in v8.3.1
Correzioni
- 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
Aggiornamenti in v8.3.0
Funzionalità
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'.
Correzioni
Released: Oct 9, 2025
Aggiornamenti in v8.2.1
Funzionalità
- 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...