Released: Jun 18, 2025

Aggiornamenti in v8.0.6

Funzionalità

• Added support for including new items in manual filter for pivot table when refreshing a cache.
• Changed to use "PackageLicenseExpression" in the NuGet package.
• The SORT function now works more like Excel. The function now orders the results with matching values after their original sorting.

Correzioni

• Fixed issue where ExcelRangeBase.LoadFromDataTable sometimes cleared data outside the loaded range.
• Fixed issue where IFERROR did not handle arrays in the second argument correctly.
• Fixed issue where the formula string for shared, array and data table formulas were not correctly decoded if 0xXXXX encoding was used.
• Fixed issue where the internal range dictionary returns true for non-accessed ranges in rare cases, causing the dependency chain to skip calculating dependent cells.
• Fixed issue where the VBA legacy signature had an invalid ASN1 record.
• Fixed issue where DBNull.Value was not handled as null in the pivot table calculation causing an unhandled exception.
• Fixed issue during formula calculation where EPPlus does not handle double char Unicode characters (starting with a high-surrogate char and ending with a low-surrogate char) correctly. EPPlus will handle this if the new EnableUnicodeAwareStringOperations property on ExcelCalculationOption is set to true.
• The TEXT function should handle arrays as input and be able to return an array instead of a single value.
• The SORT function did not handle multiple indexes (second argument) correctly.
• The SWITCH function did not handle an array as the first argument.
• Fixed an issue that caused an Exception during calculation if an external workbook was not available.
• A CircularReferenceException was thrown with dynamic arrays even if options.AllowCircularReferences was true.
• Fixed several bugs and tweaked performance for binary lookup for the lookup and match functions.