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 returns the interface IExcelNumberFormat rather than the ExcelNumberFormatXml class. All public variables remain the same and it can be safely cast to 'ExcelNumberFormatXml' as long as 'Package.Workbook.NumberFormatToTextHandler' is null.

Correzioni

• Fixed issue where deleting pictures in cells, caused a corrupt workbook in rare cases.
• Fixed several formatting issues when reading and writing tables with checkboxes in them.
• Fixed several issues when using a custom ExcelPackage.Workbook.NumberFormatToTextHandler.
• Fixed unary minus coercion on dynamic array results.
• Fixed off-by-one in 'InsertAndShift' resize condition. This caused an 'ArgumentException' when calling 'InsertColumn' on xlsx files where the number of defined columns was at the array boundary.
• Fixed culture-specific DateTime in PowerQuery metadata.
• Calculated field computation in pivot tables did not work correctly in some cases.
• Copying a Connection shape from one workbook to another caused an unhandled exception.
• Having the wrong content type/extension on an image in the workbook package, caused an unhandled exception on load.