Released: May 14, 2025

Updates in v8.0.4

Fixes

• SUMIFS, AVERAGEIFS and COUNTIFS sometimes miscalculate due to returning the incorrect addresses to the dependency chain.
• Range.Sort did not sort update formula addresses in some cases.
• Fixed array support for the SUBSTITUTE, SUMIFS, AVERAGEIFS and COUNTIFS functions.
• Incorrect handing of meta data strings caused a corrupt workbook in some situations.
• License key validation did not work in Blazor WASM.
• The ExcelPicture.Image.Bounds was not set when loading drawings.
• Pivot cache fields containing error values only, caused a corrupt workbook.
• Pivot table date and number grouping can now handle empty cells.
• Pivot table caches did not always reflect renamed/deleted fields in a source range when refreshing.
• Concatenating two arrays or results of array formulas with the "&" operator sometimes yielded unexpected results.
• A default options variable for RecyclableMemoryStream was initiated even when UseRecyclableMemory was set to false.